Pull records from 3 Years ago

[SeekerFan]

How do I set up a query to pull records 3 years from the current date?

 

[KARL DEWEY]

You did not say what span of time the record set was to cover.
Try this and finish it for the time span --
Between DateAdd("yyyy",-3,Date()) AND xxxx

 

[Duane Hookom]

Three years prior or future from the current date? Do you only want records
for the single date or a range of dates spanning three years?

The first place to start is to understand the DateAdd() function. I expect
part of your criteria might include:
DateAdd("yyyy",3,Date())
or
DateAdd("yyyy",-3,Date())

 

[SeekerFan]

The records go back as far as the 1970's. We have time and service that are
granted every three years. What I'm trying to do is set the query up to find
new employees who have not been awarded anything yet?

 

[KARL DEWEY]

You need two queries (unless you know subqueries). First to pull records of
all that have received their awards.
Use this --

=DateAdd("yyyy",-3,Date())

Then an unmatch query to see who did not receive an award.

 

[SeekerFan]

I want all of the records of those who have worked here more than three years
and have not received a time and service award that we give out every three
years. This is a query we hope to run every quarter, which is why I need it
to be based off of the current date.