Determining Holiday Dates for Athletic Game Schedules

[BeckR]

Hello:

Thanks for reading my post. I am trying to generate Athletic League schedules using Access 2003 and Windows XP PRO. I am using DateSerial in a text box to print the game dates on the League schedule report. This is the control source for one of the dates on my report.

=DateSerial(Yea r([Date2]),Month([Date2]),Day([Date2]+7))

The problem I am having is that if the day is a Holiday then I do not want to print the schedule information for that particular day, I want to print for example "NO GAMES".

How do I determine which dates are Holidays, and then skip the printing of a particular game day?

Thank you for your assistance.

[Stewart Ross]

Hi BeckR. You need to think how you would do something like this manually, as if you can come up with a way to do so it guides you how to automate it. So how would you yourself determine what is and is not a holiday? You would look up a calendar showing holiday dates for that year.

That is what you will need to build in to your application. A calendar is just a specialised form of table covering one complete year, so in your application you must provide a holiday table where you list the dates (and names for reference) of each and every holiday that you don't want included in your league dates.

You can automate certain rules without the use of a table (for example, if it was always the case that no matches would be played on Mondays) - but holiday dates are not automatable as there are always annual variations in when these occur within the year, and there can also be local holiday variations in the designated holiday dates within a particular geographic area. A table of dates updated annually and then used as comparators in your printing routines is the only way you can accomplish what you ask.

-Stewart

[BeckR]

Hi Stewart

Thank you for the information and pointing me in the right direction. I think I know what I need to do now.

BeckR