I am trying to create a view, which among others, has 3 fields- Debit, Credit, and Balance-(which is the present running cash balance). For the Balance, it requires the (sum of all credits)-(sum of all debits), but only upto that point (record). My problem, when I specify it that way, I get only one row in the view, showing the total of all debits and all credits for the entire table. Could someone help me with this one ? Thanks.

Regards,

Steve.