grand total of report footer totals?


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

Advertisements

F

Fons Ponsioen

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

Advertisements

B

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

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

Similar Threads


Top