Hi,
Appologies for the simple (I think) question. And i cant find an answer from the forum so far.
I have a number of fields (6) of which one is a customer number, another is an outstanding balance field. Now one customer number can have several outstanding balances. What i would like is to have the customer number appear only once, with the total of all the outstanding balances showing rather than duplicate customer numbers.
Am i right in thinking that i should be using the Group By or the Sum function?
This is how my script looks at the moment:
LOAD
Absolute_Balance
BP
Dunning_Level
Dunning_Procedure
Last_Payment_Received_Date
CA
FROM
WHERE
Many thanks.
EXISTS (BP) ; (qvd )
