access dates

[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

 

[Fredg]

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

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