multiple counts on one report - do I need a subreport?

A

AccessNeophyte

Hi All,

I have a report that needs to total 2 different things: Bed Days, and
Clients Served. Each of these is broken down by Contract: ASOC or
SACPA.

I have a text box in the "Contract" Footer that counts how many
clients are under each Contract.
Name: Contract Count
Control Source: =1

I have a text box in the Report Footer that totals the Clients Served
(all clients under every Contract).
Name: Clients Served Count
Control Source: =Count(*)

I need the same report to total:
How many days each client (under each Contract) was in residence
during the report period (Bed Days),
and
The total Bed Days for all clients under every Contract.

Does this call for subreports, or is there some way I can do this
within one report?

Any help is sincerely appreciated!!!

Thanks,
Access Neophyte
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top