How to Sum Two Sums in Report

[Rachael]

I have a report where, in the footer, I need three totals:

Total Employee Amt
Total Spouse Amt
Grand Total Amt

To calc the employee amount, I use:
=Sum([EE Face Amt])
This works fine, as does the comparable formula for the total spouse amount.

How can I easily calculate a grand total of all employee amounts and all
spouse amounts?

 

[Bob Larson]

Rachel:

Use =Sum([EE Face Amt]) + Sum([Spouse Amt])

Where Spouse Amt is replaced by your actual field name


--

Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP
Free Access Resources at http://www.btabdevelopment.com

 

[Rachael]

Thanks. I had tried this, but apparently I must have been missing a
parentheses or something, but it works now.

Thanks for being a second set of eyes.

Have a good one ...

Rachel:

Use =Sum([EE Face Amt]) + Sum([Spouse Amt])

Where Spouse Amt is replaced by your actual field name


--

Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP
Free Access Resources at http://www.btabdevelopment.com

I have a report where, in the footer, I need three totals:

Total Employee Amt
Total Spouse Amt
Grand Total Amt

To calc the employee amount, I use:
=Sum([EE Face Amt])
This works fine, as does the comparable formula for the total spouse
amount.

How can I easily calculate a grand total of all employee amounts and all
spouse amounts?