You could try:
SELECT *
FROM YourTable
WHERE YourDateField Between Date() And DateAdd("d",-7,Date())
If you are in query design mode instead of SQL mode just type the following into the criteria for your date field:
Between Date() And DateAdd("d",-7,Date())