Getting multiple reports using one date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 4 queries ( Reports) that report different data. As it stands now, I
have to open each query independantly and enter the same date seperatly to
extract the data. Is their a way where I can enter the date one time and get
data for all 4 query( Reports)
 
Nick,

Use a form for your parameter entry. Make a simple form named, say,
frmReportParameters, with an unbound textbox (or, better yer, calendar
control for a date) named, say, txtDate; then in your query design, in
the criteria line where you currently have [Enter Date] or something,
use instead:

Forms![frmReportCriteria]!txtDate

so the query will pick up the date entered in the form (provided the
form is kept open). Of course, you can run as many reports as you like,
for as many time each as you like, with a single parameter entry, as
long as their queries are modified to pick up the parameter from the form.

Having done this, why not take it a step further? Add command buttons on
your form to open the reports, it's a piece of cake wit the command
button wizard, and your app starts getting a pro look!

HTH,
Nikos
 
Back
Top