Year Planner

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to put together a database which controls all the holidays &
absences for the employees at our company and need to show each employees
yearly history on a form. My problem is that I cannot seem to get the
required number of controls into the underlying query (for a whole year you
need 372 days)...

Can someone assist please?
 
Huh? Why would you need 372 controls? What is your table structure here?

You would simply build a table that includes a HOLIDAYDATE and a
HOLIDAYDESC. Then add records for each.

What specifically are you trying to do?
 
Hi Rick,

What I am trying to achieve is a form that lists the Month down the left and
then the days (1 to 31) across the top - this would give you 372 spaces in a
PLANNER style (I was thinking of a crosstab query). Then, according to
category, I am aiming to colour each different block (i.e. green = holiday
etc). Maybe this cannot be done in Access, but that is all I have to work
with at the moment.

Dave T
 
Back
Top