S
SeekerFan
How do I set up a query to pull records 3 years from the current date?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
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
Try this and finish it for the time span --
Between DateAdd("yyyy",-3,Date()) AND xxxx
D
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())
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())
D
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
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
S
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?
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?
K
KARL DEWEY
You need two queries (unless you know subqueries). First to pull records of
all that have received their awards.
Use this --
Then an unmatch query to see who did not receive an award.
all that have received their awards.
Use this --
=DateAdd("yyyy",-3,Date())
Then an unmatch query to see who did not receive an award.
S
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.
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.
D
Dale_Fye via AccessMonster.com
So, do you have a field which indicates whether they received a Time In
Service Award?
Dale
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.[quoted text clipped - 14 lines]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