Week Calander View

[bowserj]

I am trying to create a report to display an employee's schedule in the following format:

Sunday Monday Tuesday Wednesday Thursday Friday Saturday

Time Time Time
Location Location Location


I am at a loss as to how to make this work. I tried making columns and setting it up to go to a new column before each date, but it the employee does not work at all a day then it throws the column alignment off and it does not work. If I could figure out how to tell the report to leave a blank i think it should work, or I am open to any other suggestion as well.

Thank you

 

[dhookom]

There are sample calendar reports at

http://www.access.hookom.net/Samples.htm.

Duane
Hook'D on Access
MS Access MVP