Show last weeks worth of data between certain days

[mosh]

Hi all,

I need help on a query that can produce data in the last week (Thursday - wednesday) minus the weekend.

the report is run on the thursday for the previous week. Any help appreciated.

Thanks
________
Colorado medical marijuana

 

[neileg]

Presumably you need to select a date. Assuming you do this in a form and you select the week ending (Wednesday), then you need a criterion on your date field like this:

(Between (Forms!MyFormName!MyDatePicker -6) and (Forms!MyFormName!MyDatePicker -4)) or (Between (Forms!MyFormName!MyDatePicker -2) and (Forms!MyFormName!MyDatePicker))