Report totals

[Emma]

Hi I have a report with 4 sub reports. Each sub report has a Count(*) in it.
I would like to be able to add these up in the main report. But I'm only
getting a grand total which is incorrect. How can I add each subform's
counts? For example I would like a grand total of all the advocacy's (a sub
form) done.

 

[Arvin Meyer MVP]

One of the problems in adding subtotals (totals from several subreports,
each of which should have that total in a footer) is that if one of them is
Null, there will be an error. The best way of handling this is something
like:

http://www.mvps.org/access/reports/rpt0007.htm

or:

http://www.mvps.org/access/forms/frm0022.htm

 

[Emma]

I understand what you're saying but let me clarify a bit. I have 4 subreports
Advocacy, Financial, Information and Personal Support. For each client I give
a listing of these services and a count(*) of the number they got. What I
would like to do is count for all clients the number of Advocacy, Financial,
Information and Personal Support they got separately. Right now all I can get
is a grand total using sum. Is there another function I can use to do each
subreport?

 

[Arvin Meyer MVP]

Yes. Count

=Count([ControlName2Count])