Create a year to page calendar

K

Keith

I have a database that stores holiday information for the staff. The database
holds the start and end dates of the holidays that have been booked.

What I want is a report and/or form that shows an entire year for a member
of staff and by interigating their records be able to show which days they
are on holiday.

Every time I try to work it out I endup with huge tables containing an entry
for every day in the year for every member of staff.

There must be a better way. I am even open to linking the data to Excel if
that will help.

Can anybody help.

Thanks

KeithI have a database that stores holiday information for the staff. The
database holds the start and end dates of the holidays that have been booked.

What I want is a report and/or form that shows an entire year for a member
of staff and by interrogating their records be able to show which days they
are on holiday.

Every time I try to work it out I end up with huge tables containing an
entry for every day in the year for every member of staff.

There must be a better way. I am even open to linking the data to Excel if
that will help.

Can anybody help?

Thanks

Keith
 
Top