Report : Auto Select Prior Week

[JK]

Access 2003

I'm trying to run a report with a command button that automatically selects
one week prior to the day I run the report. I don't want to select a date
range each time (it will always be one week).

I'm looking for the critera script that will only select fields where the
datefinished field falls between today and one week prior to today.

I thought this would be a common thing... But I can't seem to find it
anywhere.

Thanks for your help!
Jason

 

[fredg]

Access 2003

I'm trying to run a report with a command button that automatically selects
one week prior to the day I run the report. I don't want to select a date
range each time (it will always be one week).

I'm looking for the critera script that will only select fields where the
datefinished field falls between today and one week prior to today.

I thought this would be a common thing... But I can't seem to find it
anywhere.

Thanks for your help!
Jason

As criteria on the Date field, write:
Between Date()-7 and Date()

or you could use:
Bewteen DateAdd("d",-7,Date()) and Date()

 

[JK]

It's amazing how frustrating a simple thing like this can be...
I really appreciate your help... Works Perfectly.

Jason