Report that gives previous weeks data?

[blogmad]

I need to create a report that gives me the data from the previous accouting week. For example, if I try to display the report on a wednesday, it will give me the data from monday to sunday of the previous week. The same thing will happen if I print the report on thursday. I.E. I should still get the same data from the previous accounting week (ie mon to sun).
I know how to manually set parameters in the query that feeds the report, but I'm thinking that there must be a more automated way of doing this. Hope I made myself clear? Help appreciated.

 

[blogmad]

Thanks,
I got and answer to this question now.....date query criteria should read

>=DateAdd("d",-7-(Weekday(Now())-1),Now()) And <=DateAdd("d",(-6-(Weekday(Now())-1)+6),Now())

 

[Rich]

Replace Now() with Date(), otherwise you'll get unpredictable results