Date Variables in a Report

[zoellerman]

I run a report from a query every week to get the previous weks data. I change the the date ranges in the query in design view.
Is there a way of selecting a date range to run a report without having to alter the query in design view.

 

[cghoga]

in query design add...

For your date field in the criteria ad below

Between [Enter Beginning Date] And [Enter Ending Date]

hope this helps.

 

[zoellerman]

Is there any way of changing the date ranges without having to go into design mode.
A way of putting in the date ranges prior to running the report?

 

[traingamer]

You only need to modify the query ONCE. Then each time you run the report, you are prompted for the dates.

Alternatively, you could use a form to prompt for dates. See:
faq702-3619

(This would also require the query being changed ONCE).

traingamer

 

[SkipVought]

Hi,

If your are getting the previous week's data, there is NO NEED to enter anything at all! You can CALCULATE last week's start and end dates relative to the current date.

Skip,
[sub]
[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?" [/sub]

 

[zoellerman]

I get it now, cheers