Generate a free / busy type of calendar in Access

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.

Wow, my brain just isn't grasping either solution. So I'm attaching a copy of the data in Excel format so you can see what I'm dealing with. The finished report should be by worker name with each client down the Y axis and times of day along the X. My hope was to have blocks filled in for the duration of each visit with a client above the corresponding time. Sorry I'm being kind of dense here. missingshifts.xls

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

@ boaq2000 - Thanks and I understand. After some research and failed attempts I beginning to believe it will not be possible considering the amount of data I have to chart. The report is to help us find holes in our scheduling of clients. I'm going to try a bit more with the solutions both of you have provided and if I cannot accomplish it then I will most likely close the question and split points between you.

Featured Post

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…

I see at least one EE question a week that pertains to using temporary tables in MS Access. But surprisingly, I was unable to find a single article devoted solely to this topic.
I don’t intend to describe all of the uses of temporary tables in t…

Learn how to number pages in an Access report over each group.
Activate two pass printing by referencing the pages property:
Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things into separate tables:
Make sure that all record…