Not sure if this can be done

[Lori]

I keep track of people's vacation days, my manager wants to see the entire
year on one page, in the form of a calendar, that can be printed out by
individual. She wants it to look like an annual calendar. How would I be able
to format this report?

 

[Duane Hookom]

Can you share your significant tables and fields? Do you want one calendar
per person? Or, do you want multiple people per calendar? What does your
manager want to see other than the month and day?

I think my first step would be to create a table of all days for this year
and several years into the future.
tblCalendar with a date field named CalendarDate

 

[Lori]

I created a table already that have the date field, day of the week, and
month, it lists the days for 2007 and 2008, with additional fields to
indicate weekend days and holidays so that if someone were to put in a range
of dates we could subtract out those days from the total being used. She
wants to see the entire year on one page, showing all twelve months. I
currently have a table called tblDaysOff which lists the dates people have
taken or scheduled this year.

I guess the real question is how do I set up the report so that I can show
the whole year.

 

[Duane Hookom]

This isn't simple and you didn't answer "Do you want one calendar per person?
Or, do you want multiple people per calendar?"

I have created a sample for you that you can find at
http://www.access.hookom.net/Samples.htm. Notice the annual calendar with
days off. It uses cartesian queries, a month subreport, code in reports etc.

 

[Lori]

I need one calendar per person, I know I can use conditional formating to
change the color of the text to indicate an entry (that's all I really need)
but will the conditional formating allow me to change the background color as
well. (i.e. if they have a vacation day scheduled the background is blue, if
the have a comp day the background is green?)

 

[Duane Hookom]

Lori,
I spent a fair amount of time creating (modifying an existing report),
zipping it, and creating a link on my web site for you (and possibly others).
Did you download and run the report? The report lists a full year for each of
the two individuals in the tables.

You could add a field to tblDaysOff to identify the type of day off and then
use conditional formatting.

 

[Lori]

Thank you, I'll check it out and see modify my table to meet this sample. I
appreciate all the help.