Last week's data

[danassef]

I'm trying to retrive my data from last week. As you know last week contains four days from the year 2014 and the other three occured in 2015. When I run my query I get only the data from 2015 and none of my data from 2014. I have an expression in my query of:



Year(date())*53+DatePart("ww",Date())-1

I run this query once a week on Monday or Tuesday and prior to the change in the year it worked just fine and gave me the data I need from the previous week, but now with the change in the year it is not giving all my data. How can I write this express to include the data from the previous week even if there is a change in the year?

[June7]

You want data for an entire week regardless of what period (month, year) the days are in? Only way I know is to calculate the date for first day of week a given date falls in and use that date for filter parameter.

Review https://www.accessforums.net/access/...eek-42413.html

[trevor40]

You want data for an entire week regardless of what period (month, year) the days are in? Only way I know is to calculate the date for first day of week a given date falls in and use that date for filter parameter.

can't you just use date()-7 ?
gives the date for 7 days ago.
based on you using date() as a reference for the start date, change it to whatever then " -7 " gives the start date less 7 days for that period.