Running balance query

[Mike Hughes]

I have this query and it contains a Payment field and a Deposit field.
Would someone show me what I need to do to generate a running Balance field for each row ?

In some rows there will only be a payment value entered or only a deposit value entered and it is also possible to have both a payment value and deposit value in the same row.

SELECT Table1.Date, Table1.[Check #], Table1.[Issued To], Table1.Description, Table1.[Case ID], Table1.[NCP/PF], Table1.Child, Table1.State, Table1.Payment, Table1.[Deposit Date], Table1.[Deposit Amount], Table1.Balance, Table1.Cleared
FROM Table1
WHERE (((Table1.Date) Between [START DATE] And [END DATE]))
ORDER BY Table1.Date, Table1.[Check #];

I have attached a sample DB

Thanks Mike

 

[Mike Hughes]

I got what I believe to be the query