I don't quit understand what your saying, but then again I'm new to access.
The reason I have the expires in there is so I can look up triaing dates per
person and per subject trained on. I also wanted to do a montly report that
told me who has training that is to expire that month.
Well, Let's say I took a class March 1, 2005. You are saying that the
training will expire March 1, 2006, right? If you always require the
training one year later, then you don't need to store a new field for that.
You *know* that it expires one year later, right?
To run a report today, you would simply build a query to pull all records
where the training was done between February 24, 2005 and March 24, 2005.
Correct? Those people are the ones who must retake that class in the next
30 days.
If all that logic is correct, then you really only need two fields in your
table (Name, DateTrained).
To create your report, you must create a new query. Include the two fields
from your table. In the "CRITERIA:" under the DateTrained, you have to put
some kind of criteria to tell it to only pull records where the date is
between February 24, 2005 and March 24, 2005. The most obvious way to do
this would be to put...
Between 02/24/2005 and 03/24/2005
That query could then be used as the record source for your report.
Now, doing it like that means that you would have to go in and revise the
criteria in your query every time you run it. Let's improve on that and use
some variables instead of entering set dates. To do so, change that
"CRITERIA:" entry to the following....
Between DateAdd("m",-12,Date()) And DateAdd("m",-11,Date())
That will give you all the records where the DateTrained is between the
current date minus 12 months and the current date minus 11 months.
Hope that helps.

Signature
Rick B
>I don't quit understand what your saying, but then again I'm new to access.
> The reason I have the expires in there is so I can look up triaing dates
[quoted text clipped - 33 lines]
>> >
>> > Scott
Learning Access - 25 Feb 2006 07:54 GMT
Thank you for your help. I added the line to the date trained criteria but I
don't know how to set up the report. I have tired to make the report to show
that, but the fields come up empty.
Scott
> Well, Let's say I took a class March 1, 2005. You are saying that the
> training will expire March 1, 2006, right? If you always require the
[quoted text clipped - 68 lines]
> >> >
> >> > Scott
Learning Access - 25 Feb 2006 07:55 GMT
I'm sorry, I meant to ask if that criteria will work on Medium date? I set
the Date Trained to be enter as DDMMMYYY.
> Well, Let's say I took a class March 1, 2005. You are saying that the
> training will expire March 1, 2006, right? If you always require the
[quoted text clipped - 68 lines]
> >> >
> >> > Scott
Rick Brandt - 25 Feb 2006 13:05 GMT
> I'm sorry, I meant to ask if that criteria will work on Medium date?
> I set the Date Trained to be enter as DDMMMYYY.
Date formatting is merely a display and entry issue. It has zero effect on how
the dates are stored and thus has zero effect on the format you use for
criteria.

Signature
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com