grand total of report footer totals?

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

 

[Fons Ponsioen]

Why not use:
=Count([fieldname])+Count([fieldname2])...etc
This would sum the totals.
Hope this helps.
Fons

 

[BarbaraH.]

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

.