Query to get last week's data

[BigVinnie]

Hello all,



I have a select query where I always want to retrieve the data from last week (Monday to Sunday) without inputting the date in the query.
The criteria is currently BETWEEN #04/02/2018 AND #11/02/2018. Rather than replacing a hard coded date each week I want to use an expression instead. So if I was running the query on Wed 20th Feb I want to return results for the week commencing Mon 11th Feb.

From searching on the Internet it appears that I requires a combination of date functions. I tried Between Date() - ( 6 + Weekday(Date(), 2)) AND Date() - Weekday(Date(), 2) but this is not returning the right results.

I am new to this type of query so any help would be much appreciated.

Many Thanks

Vinnie

[CJ_London]

so basically you want to run the query for last week, regardless of when you run it this week?

your formula works for me - it returns 4th-10th- my only comment is you say 'BETWEEN #04/02/2018 AND #11/02/2018' - that is 8 days, not 7 - and today is only the 17th we haven't reached the 20th yet. I f was to run on the 20th it returns 11th-17th

[BigVinnie]

Thanks for your response. It seems to be working now! Database having a moment