pulling dates 90 old

  • Thread starter Thread starter Sheri
  • Start date Start date
S

Sheri

Thanks for the help. I am using Access 2000. My problem
is that I have a date field and I need to pull dates that
are 90 days old and older. I need this to be done on a
daily basis using the current date when I run the query
without typing in any dates. The name of the field is
DelDate.
 
In your query design, under the DelDate field, place in
the criteria block <=Now() - 90 This should bring back
the correct records.
 
Back
Top