Query to show all records before todays date

[dan_s]

Hi,
I'm quite new to Access, and would like help with a query.

I need to show all records with the date field 14 days before todays date.

If i havn't explained this clearly enough then i'll have another go.

Thanks

Dan

 

[Mike375]

Put <(Date()-13) on the Criteria row for the field in question

 

[dan_s]

Thanks very much!