not sure i understand your idea of 'quarterly'. for me the year in quarters is:
1st qtr: jan-mar (1-3)
2nd qtr: apr-may (4-6)
3rd qtr: jun-aug (7-9)
4th qtr: sep-dec (10-12).
you can't use a qry with criteria = 4th qtr?
Assessments are done every 90 days on each person in our building. A larger assessment is done Annually which is called an MDS. The term quarterly refers to a smaller assessment done every 90 days until a new Annual MDS is done. That's why the columns are named as they are.
For this purpose it is the dates that matter as they are the closing date for the assessment and also the date I use for the meeting and do not reflect a quarterly time period. They also don't correspond with the calendar quarters, Just 90 day segements of time based on when the person arrives in our building.
I enter each date into the appropriate column on the table as I schedule the assessment. I just need to get the report to identify and use the date that would be greater than the current date and choose that one (out of the 4) to put on the report, that is actually an invitation to the meeting.
Though I myself haven't used it, there have been many on here that have used the DateAdd function which can give you periods of time in dates ahead or behind the current or stated date. Either check in the forum here or in the Access online help files.
hi. i was fooling around with some date code and came up with this:
Private Sub DateTest()
Dim Today As Date
Today = Now
Select Case Today
Case Today > #1/2/2004#
Case Today > #3/2/2004#
Case Today > #6/2/2004#
when you run it the result will come up in the immediate window. you'll have to play with it to get it to output where and the way you want. is this what you're after?