FINDING RECORDS BY DATE

[Mksmall]

Can someone help me pull in information from a table that is older than 30 days from the current date. I need the criteria to use in a query. I want to find records that are older than 30 days.

 

[JGillespie]

The SQL to select all records from Table1 where a field called 'date' is more than 30 ago would look like this:


SELECT * FROM Table1 WHERE ((Now()-[Table1]![date]>30));


Hope this helps! Jamie Gillespie
j-gillespie@s-cheshire.ac.uk