Same report, different data - is this possible?

[Tara]

I have a billing report that requires the data to be broken down by county
and service provided. Each county and service within that county are
required to have their own header that is repeated on each page as well as
their own billing total which needs to only show on the first page header for
that county/service. I could have the user choose a county and service from
a combo box and then run each report separately, however, the user would be
required to then run the report 12 different times, which will get
frustrating I'm sure. The only other solution I could come up with is to see
if I could instead make one command button that would run the report 12 times
using the various combinations of criteria, one right after the other. Is
this possible?

 

[Jeff Boyce]

Have you looked into using the Sorting/Grouping feature?

I suspect you could use Grouping to get your report "by county" and "by
service".


Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Tara]

Yes, I can do that. But unless I'm missing something or am not thinking
clearly, that won't quite give me what I need. The part I'm struggling with
is the billing total issue. The Page header has to appear on each page and
the page header has to list the billing total for that specific county and
service, but it can only list it on the first page.

 

[Jeff Boyce]

Tara

I may be mistaking this for something else, but I thought there was a
property connected with the section that allowed for the information in a
section to be repeated each page.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP