Criteria for displaying records for a given week

[Rob500]

Hi guys

I'm a little stuck on three of my nine queries. Bascially, three of them display records for a given day, three for a given week and three for a given month. The criteria for days and months was pretty easy; I just got:

[Enter Date]

for a single date

DatePart("m", [Date]) = [Month]

for a given month

However, I'm really stumped on how to work out the criteria needed for working out records for a given week. All I managed to work out was:

<=[Week Ending] And >"Date[Week Ending]-7"

This works when there is no test data, but not when there is. I know it's something to do with the -7 bit, but I can't work out what.

Please help

Thanks

 

[Rob500]

UPDATE: Done it