How to calculate a total on a report

[Adigga1]

Hello everyone,

I have a problem with adding a formula on a report in order to calulate the Total of a client's "charges" (field name).

Can someone assist me in this area: what formula or condition can I input into the design view of the report to Sum or Total the "charges" field of the report.

Thanks in advance

A....

 

[pbaldy]

Try

=Sum(Charges)

in a group footer or the report footer.

 

[SOS]

And I would suggest that you rename the control to txtCharges if it is named the same as the field. Then you use the FIELD name for the function

=Sum([Charges])

If they are named the same, then many times you will get #Name as the output.

 

[Adigga1]

Try

=Sum(Charges)

in a group footer or the report footer.

Thank you for the sugesstion; I will try this

A..

 

[Adigga1]

And I would suggest that you rename the control to txtCharges if it is named the same as the field. Then you use the FIELD name for the function

=Sum([Charges])

If they are named the same, then many times you will get #Name as the output.

Thank you for the post; I will try this

 

[Adigga1]

I'm having another issue: I have also included 2 screen shots of this issue.

I'm now recieving som funky printout when I included =sum(charge) condition within the detail and footer of the report page

take a look at the screen shots, I will include the resulting report in a followup post. Thanks for you help

A...

 

[Adigga1]

Here is the resulting Report

 

[SOS]

It doesn't go in the DETAIL section, it goes in either a GROUP FOOTER (which it appears you don't have one) or the REPORT FOOTER.

 

[SOS]

Actually, you do have AcctNum header, so you need to add the footer for that group and put the text box there.

 

[Adigga1]

Actually, you do have AcctNum header, so you need to add the footer for that group and put the text box there.

I apologize for my naivity in this: this was an existing project my job asked me to look at, how do I navigate to add the footer for the report?

Thanks

 

[SOS]

I apologize for my naivity in this: this was an existing project my job asked me to look at, how do I navigate to add the footer for the report?

Thanks

While in Design view of the report, right-click the gray area at the bottom of the report. Select SORTING AND GROUPING. When that appears you should see your group and there will be an option named

MORE>

which you can click on and that will show the options including to add a footer.

 

[Adigga1]

While in Design view of the report, right-click the gray area at the bottom of the report. Select SORTING AND GROUPING. When that appears you should see your group and there will be an option named

MORE>

which you can click on and that will show the options including to add a footer.

Thank you very much SOS for this tip i will try, test and report back to the forum the results. Thank you again

A...

 

[Adigga1]

SOS, Here is the report, it works great. thanks again for all your help

 

[SOS]

Glad we could assist.