Getting an error on Report after formula.

D

Dustin

Hi There,

I am trying to show the Grand Total number in the Page Footer but all I get
is an error when I view the report. My formula goes like this,
=sum([DescriptionTotals]), DescriptionTotals is an expression in a query that
looks like this DescriptionTotals: =Count([HeadDescriptions]).

I am not sure what I am doing wrong.

Thanks Dustin
 
F

fredg

Hi There,

I am trying to show the Grand Total number in the Page Footer but all I get
is an error when I view the report. My formula goes like this,
=sum([DescriptionTotals]), DescriptionTotals is an expression in a query that
looks like this DescriptionTotals: =Count([HeadDescriptions]).

I am not sure what I am doing wrong.

Thanks Dustin
Click to expand...

See Microsoft KnowledgeBase article:
123017 "How to sum a column of numbers in a report by page"
 

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

Wrong Sum in Report Footer 2
Totaling An Aggregate Expression On A Report 4
How to Sum Two Sums in Report 2
Count Value in a report footer 1
Grand Total in a report 4
#Error in report footer 3
Decimal places in report 2
Calculating a grand total for an unbound control in a report 9

Top