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
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