Help! Running deduction Calculation

[BenJones]

I have created a database that hold customers and their agreements. I have a preset facility amount (the total the cust can borrow) and wish to deduct each new agreement from this amount and display the running total.

I have created a module to do this but it only deducts the total of each agreement seperately.

How can I get it to keep reducing after each agreement no just do the calculation once per record?

Any help would be appreciated

Thanks

 

[KenHigg]

I would think you could do a dsum() for this...

???
Ken

 

[BenJones]

Thanks...

So in my query I would need a DSum that says TotalFacility - AgreementAmount

Would this be a running deduction total though?

 

[KenHigg]

Hum... Not being sure of exactly how you're set up, I would start by trying to just have an unbound text box on the form and use the dsum() there.(?)

Ken