limit calendar date range

[mazza.j]

I have a database that uses a programmatically created calendar form that
tracks employee sick time use. The data is based on a standard calendar year
(Jan 1 - Dec 31), and each year the tracking process starts fresh. I want to
store each year's data in its own table whose title would simply be the year
of the data store (e.g., 2009, 2010, etc.). As such I want and need the
calendar to only display the date range for the year/data selected, which may
or may not be the current year (e.g., If 2009 is selected, the calendar only
displays Jan 1 thru Dec 31 of that year and is stored in the table entitled
"2009"). Choosing a different year would restrict the date range to that year
and in the respective table.

 

[Klatuu]

You should have only one table, not one for each year. That actually makes
everything harder when you do it that way. The correct solution is to use a
query as the source for the form that is filtered based on the selected year.

If you can describe how you select the year, and how you know which records
constitue a sick day, we can help you make it happen correctly.