Summing in page footer

  • Thread starter stephendeloach via AccessMonster.com
  • Start date
S

stephendeloach via AccessMonster.com

In my page footer section of a report I need to have a "Subtotal" which is
"NonTaxable" + "TaxableNetAmt". Sometime my TaxableNetAmt will be 0. How can
I make the Subtotal be the sum of NonTaxable and TaxableNetAmt? I have tried
many different ways and I get #error. My control source for NonTaxable is =
[NetAmount] and the control source for "TaxableNetAmt" is TaxableNetAmt. Or
will be entered on teh form... THanks
 
F

fredg

In my page footer section of a report I need to have a "Subtotal" which is
"NonTaxable" + "TaxableNetAmt". Sometime my TaxableNetAmt will be 0. How can
I make the Subtotal be the sum of NonTaxable and TaxableNetAmt? I have tried
many different ways and I get #error. My control source for NonTaxable is =
[NetAmount] and the control source for "TaxableNetAmt" is TaxableNetAmt. Or
will be entered on teh form... THanks
Click to expand...

See Microsoft Knowledgebase article
132017 "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

Summing expressions per group in a report 3
Summing in a group footer 5
Total not correct in Footer 1
Summing in a Report Footer 7
count in parent report footer 2
A03 - count in report footer gives me #Error? 0
Page Footer 1
REPORT FOOTER ON SEPARATE PAGE 1

Top