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())

 

[Dale_Fye via AccessMonster.com]

Need a little more clarification. Do you want all the records from (as an
example 6/24/2006) through today, or do you want just the records for
6/24/2006, or some other subset?

In your query grid (I assume you are using the grid to create this query),
add the field from your database that contains the date you want to compare.
Then, in the criteria row for that field, enter something like:

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

or

BETWEEN DateAdd("yyyy", -3, Date()) AND Date()

HTH
Dale

 

[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.

 

[Dale_Fye via AccessMonster.com]

So, do you have a field which indicates whether they received a Time In
Service Award?

Dale

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.

Need a little more clarification. Do you want all the records from (as an
example 6/24/2006) through today, or do you want just the records for

[quoted text clipped - 14 lines]