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

Section and Page numbering 0
Cover Page - Use "Next Page Break" rather then Page Break 0
Use "Next Page Break" instead of "Page Break" on the cover page. 0
Space at end of multi page list to accommodate new entries 1
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Report Group Footer DLookUp 0
Footer On Last Page Only Not Working 1
Page numbering with Merged Document and IF statements 1

Top