so close with running sum

[Prufrock]

I am so close I can taste it and hope someone can just get me over the line.

I have a form and subform based on a query. When I select an ID number a sub form shows me following fields:
[PaymentNumber][ID][Date][AmountDue][AmountPaid][AmountOwing][TotalOwing]

I have a calculated field in the query that takes AmountPaid from AmountDue. Sometimes not all is paid.

Now I have used a further calculated field in query that attempts a running sum of the TotalOwing. I am getting the exact amount in AmountOwing repeated in TotalOwing in each row of this datasheet form but no running sum occuring. My calculation is

Subtotal: DSum("[AmountOwing]","[qryRentPaymentsPreFinal]","[PaymentNumber] =" & [PaymentNumber])

What do I need to do to get it adding each Owing amount together? Thanks

 

[ZmrAbdulla]

See this KB from MS(

http://support.microsoft.com/kb/q182568/)

that has a download for most of all your query requirement.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.