asked on Generate a free / busy type of calendar in Access
Hi,
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.
Many Thanks!
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.
Many Thanks!
Microsoft Access
Last Comment
thyatt5473
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
@capricorn1 - Thanks, that'll take me a bit to get my head around.
ASKER
@boaq2000 - Thanks but the link does not work.
Sorry about that.
See this file:
http://filedb.experts-exchange.com/incoming/2008/05_w22/29096/Gantt2000.mdb
From this Q:
https://www.experts-exchange.com/questions/23442528/Help-with-a-Gantt-Chart-report-out-of-access.html
See this file:
http://filedb.experts-exchange.com/incoming/2008/05_w22/29096/Gantt2000.mdb
From this Q:
https://www.experts-exchange.com/questions/23442528/Help-with-a-Gantt-Chart-report-out-of-access.html
ASKER
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
Again, while I am confident that this can be done, it may take more time than I am willing to invest on a volunteer basis.
Can you post a graphical example of what you want this to look like (based on the sample data)?
Can you post a graphical example of what you want this to look like (based on the sample data)?
ASKER
@ 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.
ASKER
Here is a quick graphical example of what I hope to accomplish. One page for each worker. ![Example of shift report]()
I'll look at this tonight.
(No promises though...)
In the mean time investigate the links that capricorn1 and I posted...
(No promises though...)
In the mean time investigate the links that capricorn1 and I posted...
I could not make a determination as the data you posted was not based on the actual data in your spreadsheet (as I requested)
Sorry I could not be of assistance.
JeffCoachman
Sorry I could not be of assistance.
JeffCoachman
ASKER
Thank you both for your assistance. I'm sure your solutions work great but I could not get either one to work with my data. I will most likely pursue working with MS Project.