Calculating dates msaccess

B

Benuk73

Hi, Im trying to show only records that are over 60 days old from thei
creation date. I have a date file called input date and i only want t
see records more than 60 days old. What would the criteria be? I'v
given up on trying myself and hope somebody will be able to come u
with an answer? :thumb
 
A

Allen Browne

In the Criteria row of your query, under the date field, enter:
<= Date() - 60
 
Top