I am using Access 2000 on an ME...
I am trying to create columns from my rows based on date...
EmployeeNo
EmployeeName
ShiftDate
MinsWorked
There is a user entered start date called [Entered Date]
iif(ShiftDate = [Entered Date],(MinsWorked/60),0)
this works on the query, but then I want to do the same for day 2 day 3 etc.. for example ;
iif(ShiftDate = ([Entered Date]+1),(MinsWorked/60),0)
but I am being told that this is to complicated... is there any solution to this... I want to do this for a 7 day week?
Any help would be appreciated
I am trying to create columns from my rows based on date...
EmployeeNo
EmployeeName
ShiftDate
MinsWorked
There is a user entered start date called [Entered Date]
iif(ShiftDate = [Entered Date],(MinsWorked/60),0)
this works on the query, but then I want to do the same for day 2 day 3 etc.. for example ;
iif(ShiftDate = ([Entered Date]+1),(MinsWorked/60),0)
but I am being told that this is to complicated... is there any solution to this... I want to do this for a 7 day week?
Any help would be appreciated
