Want to sum balances due on report

[KatieK]

I have read the forum and maybe an invisible field in the detail that totals the column then pulled that value into a new text field in the footer would work. Here's what I want to do...
I have 6 records with balances due. My report currently prints only those with >0 balances. I want to total up the balances due on the report to give a nice number at the bottom. Thanks!

 

[statsman]

Using the tool bar, place a text box on the report where you would like the total (this works best if you place it into the report footer).
in the text box type ([alpha] being the name of the field with the balances due)

=Sum([alpha])

You should have a sum of all of the balances due on that report.