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