Week commencing date reporting

[Patonar]

Hi,

I have a query which works out which orders are due to be delivered in
a particular week. I would like to display this by week commencing
which i can do with the following WHERE condition in the date field:

<=(Date()) And >DateAdd('d',-5,(Date()))

Now the customer would like to be able to see the previous six weeks
data on the same report - i know i can find out the previous weeks
data by doing something like:

<=(Date()-7) And >DateAdd('d',-5,(Date()-7))

and so on minusing 7 days off for each week in the past - but doing it
this way would mean that i need to have 6 (or however many weeks i
wanted to go back) queries..

Is there anyway that i can dynamically set the where clause when the
report opens? I would be using subreports to display each queries
results...

Regards,

Andy

 

[Allen Browne]

Create a form where the user can enter the date range.

See:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html
If you are using subreports, you will need to use Method 1 of that article.