Sum of two sums

[Jen B. via AccessMonster.com]

Does anyone know how to get two sums to calculate and show on a report?

Example: I have two columns in my report: Sum of 1st Mtg. and Sum of 2nd Mtg.

I want the combined total of these two columns underneath. What is the
equation?

Also at the end of the report I want to do the same thing.

Example: At the end of the two columns I have: =Sum[(Sum of 1st Mtg.)] and
=Sum[(Sum of 2nd Mtg.)]

I want my report to show the combined grand total of 1st and 2nd mtgs.
underneath that.

If anyone has any ideas on how this is done. I'd sure appreciate it. I
cannot figure out the correct equations.

Thank you

 

[Allen Browne]

Just set the Control Source or the 3rd box to:
=[Text100] + [Text101]
or whatever those other text boxes are called.

You might want to specify that if one of the boxes is null, Access should
treat it as a zero:
=Nz([Text100],0) + Nz([Text101],0)

Also, set the Format property of all 3 text boxes to Currency (or perhaps
General Number) so Access knows they are numeric values.

 

[Guest]

Each text box (control) that contains a formula on your report is assigned a
name.
For example purposes...it may be named Text1 and the other Text2.
Text1 would have the formula: =Sum[(Sum of 1st Mtg.)]
Text2 would have the formula: =Sum[(Sum of 2nd Mtg.)]
Just create a new textbox (Text3) and enter the formula: =[Text1] + [Text2]

To find the actual name of each of the two fields, open the report in design
mode.
Right-click on each textbox and select Properties. Click on the ALL tab.
Scroll down to the Name field. It will probably say something like Text1 or
Text45 or Text120, etc. etc. Just replace the correct names in the
instructions above.

jmonty

 

[Jen B. via AccessMonster.com]

Thank you

Just set the Control Source or the 3rd box to:
=[Text100] + [Text101]
or whatever those other text boxes are called.

You might want to specify that if one of the boxes is null, Access should
treat it as a zero:
=Nz([Text100],0) + Nz([Text101],0)

Also, set the Format property of all 3 text boxes to Currency (or perhaps
General Number) so Access knows they are numeric values.

Does anyone know how to get two sums to calculate and show on a report?

[quoted text clipped - 17 lines]

Thank you

 

[Jen B. via AccessMonster.com]

Thank you

Each text box (control) that contains a formula on your report is assigned a
name.
For example purposes...it may be named Text1 and the other Text2.
Text1 would have the formula: =Sum[(Sum of 1st Mtg.)]
Text2 would have the formula: =Sum[(Sum of 2nd Mtg.)]
Just create a new textbox (Text3) and enter the formula: =[Text1] + [Text2]

To find the actual name of each of the two fields, open the report in design
mode.
Right-click on each textbox and select Properties. Click on the ALL tab.
Scroll down to the Name field. It will probably say something like Text1 or
Text45 or Text120, etc. etc. Just replace the correct names in the
instructions above.

jmonty

Does anyone know how to get two sums to calculate and show on a report?

[quoted text clipped - 15 lines]

Thank you