Dates

  • Thread starter Thread starter Steimi
  • Start date Start date
S

Steimi

I am trying to have a Query show the names of people and a date that is 90
dyas before the date that is in the query.
More clear explaination- I have a query showing a date when people are
suppose to transfer. I need to show a list of people that are getting
transferred 90 days before the date in the query.
 
I think I understand. You want to be prompted for a date to enter in the
query and then pull records that are due transfer within 90 days of the date
entered.
Use this as criteria ---
Between CVDate([Enter date (3/15/2007)]-90) AND CVDate([Enter date
(3/15/2007)])

Another criteria would list all due to transfer from now through 90 days
from now --
Between Date() AND Date()+90
 
Queries are based on tables (and on other queries). But it all starts with
the data.

What data is your query based on?

Consider posting the SQL statement of the query you are using now to try to
do this.

Take a look at Access HELP for the syntax on the DateAdd() function.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top