I am using an append query to post

[Muttley]

I am using an append query to post a payment history into a table of payments. I need to be able to show a balance outstanding total - in most cases I can achieve this easily by appending [invoice amount - payment amount] to the appropriate field.

However, if there is more than one payment (e.g. part payments by different methods), the balance outstanding will only show the invoice amount minus the last payment processed (i.e. does not take into account the sum of the payments).

I would normally use a recordset to calculate a running sum and append this instead, however the data source includes many different invoices so I can't do this.

I'd really appreciate any help with this!

TIA

 

[allanon]

Can you post your append query?

 

[Muttley]

allanon

I have managed to sort this one out since posting - can't remember how for the life of me, as this was some time ago, but thanks anyway.

Mutt