Criteria to get records not updated in last last week (1 Viewer)

Gentlemen,

I need your help as I have a query , where I have Column which shows Last Updated Date

I use the below critereia to show the records which have been updated in last 10 days or week

>=(Date()-10)

but i am stuck to set the criteria which shows me all records which is not updated in last 10 days or week ..

Please help me out

Thanks and best Regards
Farhan

you need to use a left join to your first query

Qry1 (your qry):
SELECT * FROM myTable WHERE LastUpdated>=Date()-10

Qry2 (new qry):
SELECT * FROM MyTable LEFT JOIN Qry1 ON myTable.ID=qry1.ID WHERE qry1.ID is Null

Just reverse your criteria:

< Date()-10