hi all

would the following sql in access2000 filter a table and produce only entries in the last week? i have tried it but the date field in the db is autodate so it wont let me enter any records for the last week to test it.
i added a record today and the query only finds that one so it appears to work but i'm a beginner so i could do with your opinions.

SELECT *
FROM Messages
WHERE ((Messages.MessageDate>Date()-7))
ORDER BY Messages.MessageDate DESC;