Sum a calculated total

G

Guest

I need to have in my report footer the sum of a calculated total within the
report. Is this possible?
 
G

Guest

If you have a calculated field in the report and you want to sum it, then the
common mistake that people make is that the sum on the text box name whare
the calculated field is in

=Sum([TextBoxname])

But, you need to sum on the formula that you have in the text box

=Sum([FieldName1]+[Fieldname2])
 
G

Guest

Thanks!
--
Ronnie


Ofer Cohen said:
If you have a calculated field in the report and you want to sum it, then the
common mistake that people make is that the sum on the text box name whare
the calculated field is in

=Sum([TextBoxname])

But, you need to sum on the formula that you have in the text box

=Sum([FieldName1]+[Fieldname2])
--
Good Luck
BS"D


Ronnie said:
I need to have in my report footer the sum of a calculated total within the
report. Is this possible?
Click to expand...
Click to expand...
 

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
Want Sum in Report Header of calculated field in Report Detail ? 1
Totaling An Aggregate Expression On A Report 4
Subreport On No Data 1
Rpt totals of datediff field only if checkbox of another field che 1
Creating a chart on a report 2
Summing a caluated control in a report 1
Access MSACCESS - Sorting report based on field calculated in the report 0

Top