E
excel/access-chump
Here's the scoop:
I have a form that shows an employee schedule.
---------
Date Day Address Key Charts
1/22/08 Tuesday 12345 (23) 23
1/25/08 Friday 34567 (40) 40
---------
What I would like to do is set up the form to show days that nothing is
scheduled (7 day week) to express holes in their schedules.
Currently I have 2 text boxes: Chart Min and Chart Max that allow me to
express the individual employee's limits of chart recovery for maximum
utilization. I set this to conditionally format the records if they are over
or under scheduled.
I understand that idealy I would have a table with all the dates. However,
I don't even know how to begin to set this up.
I am running Access 2003 and I don't have permissions to change the ODBC
server database I'm pulling the schedule from.
I have a form that shows an employee schedule.
---------
Date Day Address Key Charts
1/22/08 Tuesday 12345 (23) 23
1/25/08 Friday 34567 (40) 40
---------
What I would like to do is set up the form to show days that nothing is
scheduled (7 day week) to express holes in their schedules.
Currently I have 2 text boxes: Chart Min and Chart Max that allow me to
express the individual employee's limits of chart recovery for maximum
utilization. I set this to conditionally format the records if they are over
or under scheduled.
I understand that idealy I would have a table with all the dates. However,
I don't even know how to begin to set this up.
I am running Access 2003 and I don't have permissions to change the ODBC
server database I'm pulling the schedule from.