I have a table that looks like this:
Employee
Date
Start
Finish
I’m trying to get a report that looks like this:
Sun Mon Tue Wed Thu Fri Sat Bob 9-5 9-5 9-5 9-5 9-5 off off Sue off 9-5 off 5-7 7-9 off off
Date holds a full date like 11/1/1972. Start & Stop hold times like 11:30 or 22:00
I tried a crosstab, but I cant get start & finish in the same field.
Any suggestions?
Thanks!