Somecallmejosh

  • Thread starter Thread starter Running Sum
  • Start date Start date
R

Running Sum

Hello,

I have set up a report that shows delinquent payments.
In the report I have information grouped under client
name, then all items purhcased to which they are
delinquent on payment...

ex.

[Client][Item][Payment1][Payment2][CostOfItem][Balance]
Jane Doe
"x" $25.00 $50.00 $25.00
"y" $30.00 $80.00 $50.00
John Doe
etc.

I am doing a running sum, in an unbound text box, in the
detail section to add the total balance per client. I
would like to only see the balance at the end of each
group as opposed to seing it after every instance.
Here's what I'm seeing in the report...

[Client][Item][Payment1][Payment2][CostOfItem][Balance]
Jane Doe
"x" $25.00 $50.00 $25.00
Total Balance $25.00
"y" $30.00 $80.00 $50.00
Total Balance $75.00

Here's what I'd like to see:
[Client][Item][Payment1][Payment2][CostOfItem][Balance]
Jane Doe
"x" $25.00 $50.00 $25.00
"y" $30.00 $80.00 $50.00
Total Balance $75.00

Any suggestions on how to set this up so I only see 1
Total balance per client? Thanks in advance.
 
Josh,

In the design view of your report, go to the Sorting and Grouping
dialog, and put a Group Footer for the Client. Then, in the Client
Footer section thus created on the report, put an unbound textbox, with
its Control Source set to...
=Sum([CostOfItem]-[Payment])
.... or whatever your formula is (I couldn't understand the figures in
your example, so please adjust accordingly).
 
Back
Top