Beginning & end dates for several reports in same period

[Brian Larkin]

I have created a query to select record between two dates
that are entered by the user when prompted, these ar a
begining date and an end date.

I am looking for either code or macro that will allow me
to enter these dates just once so that I can run several
different report for the same period, without the need to
enter the dates each time. I am sure that these dates
could be stored in a variable which could be called when
needed.

I just need the code to be able to do this, any help and
advise greatly appreciated.

Brian

 

[Allen Browne]

Brian, the trick is to use a form where the user enters them once, and then
either use them to build a WhereCondition for the OpenReport action, or
refer to them in the Critieria of your query.

For an example of how to do this, see:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

 

[Brian Larkin]

Allen, Thanks for the information, have created the new
form and used a combination of your suggestions and it
works fine.

Brian