Summing in page footer

  • Thread starter Thread starter stephendeloach via AccessMonster.com
  • Start date 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
 
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."
 
Back
Top