Calculating Running Totals on Various Fields

[PETEHO]

I have different suppliers each being paid in the same transaction but need to keep grand totals for each set of payment details as we can pay various suppliers in a payment run :- example shown below any ideas

Supplier PaymentDets Amount TotalPaymentsforBatch
AAA111 PC101 50-00 175-00
AAA111 PC101 50-00 175-00
AAA111 PC102 50-00 100-00
AAA111 PC102 50-00 100-00
.
.
.
ZZZ999 PC101 75-00 175-00

Thanks for your help

Pete

 

[sbdt]

I am not sure what you mean exactly, but I think you want to

1. Insert a Group
2. Create a new Running Total Field.