access dates

  • Thread starter Thread starter Claire
  • Start date Start date
C

Claire

I need to have my query provide me with records that are
over 1month, or over 3months old on a daily basis, based
upon the date i entered in one of the fields.

I would like to eventually automate this process so that
access will print the reports automatically.

Any help you guys can give me would be greatly
appreciated.

Thank you
Claire
 
For dates older than 30 days, write, as criteria for that Date field:
< Date()-30

For dates over 90 days:
< Date()-90
 
Back
Top