Beginning & end dates for several reports in same period

  • Thread starter Thread starter Brian Larkin
  • Start date Start date
B

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
 
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
 
Allen, Thanks for the information, have created the new
form and used a combination of your suggestions and it
works fine.

Brian
 
Back
Top