Generate a free / busy type of calendar in Access
Posted on 2010-11-16
I have a query with the following data... Worker Name, Client Name, Time In and Time Out. What I would like to do is create a report or form that displays a sort of free / busy style calendar with times across the top and shaded areas underneath the times based on Time In and Time Out with Client Name inside the shaded area. For example if Jane Doe is to be seen from 8 until 11 I'd like the area underneath those times to be shaded in with Jane Doe appearing in the shaded box.
Please let me know if I can explain further or if examples are needed.