Help with Calendar

[alanl]

Re MS Access 2007
Is it possible to do this?
I am writing a programme in access to run an Entertainment Agency Business
I wish to look at a Calendar for any given month of any given year for any Artist I hold data on
I need the Calendar to display all the days & dates of the month along with record fields from at least three different tables
The Tables
One holds the Artists data including the days of the week they can & can't work
One holds details of contracts including performance dates and relevant details pertaining to the contracts
One holds information re holidays or one off dates that the Artist is unavailable



The Calendar display would be fantastic in the same format as in Outlook 2007 but any decent display would work

[NTC]

the calendar feature in access07 is for selecting a date to go into a control; not as a display;

you might look at Outlook primarily - and in their forum you may find ways to have the data populated from Access tables - - not sure.

there is no problem in your request in terms of a database; it is the issue of laying out the data in a calendar style screen form; if you were willing to accept the layout in normal table style records you could use Access.