Display a calendar of Access database dates

[Guest]

Could anyone help? I'd like to have our Employee database (when it's set up)
to display a given date range (say 1 month) with when any employees are on
leave (for instance to print or show for the month of December, or January,
with the employee name on the row [record] and 'columns' for each work day).
I'm currently using Excel with rows for employees, columns for days of the
week (including weekends). I colour the annual leave days (red) sick leave
(green) etc. It's a good visual for managers & staff at certain times of the
year.
I'm new to Access 2007 and am just setting up to import some Excel data, and
am not a high-end user of Access.

 

[Guest]

You might want to look at the calendar report sample at
http://www.access.hookom.net/Samples.htm.

 

[Guest]

Thanks Duane, will need a little time to assess, but that's a great start!

You might want to look at the calendar report sample at
http://www.access.hookom.net/Samples.htm.

--
Duane Hookom
Microsoft Access MVP

Could anyone help? I'd like to have our Employee database (when it's set up)
to display a given date range (say 1 month) with when any employees are on
leave (for instance to print or show for the month of December, or January,
with the employee name on the row [record] and 'columns' for each work day).
I'm currently using Excel with rows for employees, columns for days of the
week (including weekends). I colour the annual leave days (red) sick leave
(green) etc. It's a good visual for managers & staff at certain times of the
year.
I'm new to Access 2007 and am just setting up to import some Excel data, and
am not a high-end user of Access.