Accounting: Balance is 0, but can't recognize

[leadpro]

I have a query that calculates the balance of a client as the following:

Balance Due: [OrderAmount]-Count(LeadsMaster.[Home Phone])-[SumOfReturned]

Balance Due is not a field in my table, but can't seem to get this calculation to save in the table. The major problem I have is to recognize WHEN the balance is 0, then update a field OrderCommplete in the LeadsMaster table. This way I can reset the order.

 

[alvechurchdata]

I'm not sure what this statement s doing:

[TT]Count(LeadsMaster.[Home Phone])[/TT]

Is it trying to count the matching entries from another table?

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[lespaul]

why do you want to save a calculated field in a table? Breaks normalization rules. Calculate it on the fly when you need it. Have you read The Fundamentals of Relational Database Design?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[PaultheS]

Above link was broken, try this:

http://www.abcdataworks.com/fundamentals.htm

 

[lespaul]

my bad!!