Running reports sequentially?

  • Thread starter Thread starter Stan
  • Start date Start date
S

Stan

I have a database logging the number and type of telephone calls coming into
our office. There are a number of different reports providing various
statistics which the operators can run individually, each report requiring
only the start and end date for the reporting period. This is entered by a
"report-named" form,(begin_date - end_date) to a specific query thence the
report output by using the preview/print command buttons on the form.
I feel that it would be "nice" to give the operators the option of running
all the reports (12) sequentially having only to enter a single begin_date
and end_date. My head is telling me there must be a simple way of achieving
without having to redo all these reports but my skill in seeing how this can
be done is lacking.
Any kind soul who can kickstart me in the right direction????
Pleeeeeeeeaaaase
Cheers
Stan
 
I would put all the reports as subreports in one larger report.

I'd also build a form with two fields and allow them to enter the dates on
that form. I'd then use the entries in each query so it would not ask me
repeatedly.

Search for Parameter forms or query parameters for posts in these newsgroups
with more details.

Rick B
 
Thanks Rick - that's just the sort of starter info I need to get me looking
in the right direction - can stop going round in circles!!! Haven't even got
to as far as Parameter type yet.
Cheers - it's nice to know that newbie questions don't get kicked into touch
on here

Stan
 
Back
Top