grand total of report footer totals?

  • Thread starter Thread starter BarbaraH.
  • Start date Start date
B

BarbaraH.

I have four totals in the footer of a report that I am
calculating using the Count[fieldname] function.
This is because Count does not include null values and
what I want to count are all records where "fieldname" is
not null.
Is there some way for me to total these 4 totals to
include a grand total in the footer?

I have tried using the report field names where the "Count
[fieldname] values are displayed, but Access doesn't
recognize them.
I also tried doing the following:
=Sum(Count([fieldname])+Count([fieldname2])...etc
but it gave me an error message about being unable to
handle aggregate values.

Finally, the reason I am not just counting the records in
the detail list (i.e. Count(*)) is that some records have
not null values in more than one of the 4 fields.

Thanks in advance for any help.
 
Why not use:
=Count([fieldname])+Count([fieldname2])...etc
This would sum the totals.
Hope this helps.
Fons
 
Thanks - that worked. Simple is better.
-----Original Message-----
Why not use:
=Count([fieldname])+Count([fieldname2])...etc
This would sum the totals.
Hope this helps.
Fons
-----Original Message-----
I have four totals in the footer of a report that I am
calculating using the Count[fieldname] function.
This is because Count does not include null values and
what I want to count are all records where "fieldname" is
not null.
Is there some way for me to total these 4 totals to
include a grand total in the footer?

I have tried using the report field names where the "Count
[fieldname] values are displayed, but Access doesn't
recognize them.
I also tried doing the following:
=Sum(Count([fieldname])+Count([fieldname2])...etc
but it gave me an error message about being unable to
handle aggregate values.

Finally, the reason I am not just counting the records in
the detail list (i.e. Count(*)) is that some records have
not null values in more than one of the 4 fields.

Thanks in advance for any help.
.
Click to expand...
.
Click to expand...
 
Back
Top