Query Criteria Fields

[Guest]

I have developed a query which returns data that is limited to a date range.
The date field's criteria looks like: Between #8/15/2005# And #8/19/2005#

Those dates need to be changed weekly (I have another query which is set up
similarly which uses a range of a month). The way this is set up is that I
will manually change the dates of the query every Monday.

Is there any way to automate this somehow? Just looking for ideas.

 

[fredg]

I have developed a query which returns data that is limited to a date range.
The date field's criteria looks like: Between #8/15/2005# And #8/19/2005#

Those dates need to be changed weekly (I have another query which is set up
similarly which uses a range of a month). The way this is set up is that I
will manually change the dates of the query every Monday.

Is there any way to automate this somehow? Just looking for ideas.

Simplest methods....
Why not simply use one query and set it's criteria to
Between [Start Date] and [End Date]

You will be prompted for the dates.

Or.. if you wish the query to always limit itself to the current
week's data, add another column to the query grid

WeekOfatePart("ww",[DateField])

As criteria on this column, write
DatePart("ww",Date())