I have a query that starts with an invoice number. With that invoice number the next field tallies up all the items sold under that invoice with a dsum to another query. The next field is the same idea except it adds up all the payments made toword that invoice number. The next field I am trying to write a formula to find the difference between the two but it keeps showing up blank. Would the calculated field not be something like this

TotalOwing:[calcfield1]-[calcfield2]

?

Edited by: kellyrmartin on Tue Dec 18 1:11:54 EST 2007.

JET may or may not process the (calculated) Fields from left to right as we usually (and incorrectly) expect due to the QBE.

To be 100% sure the difference calc will be performed correctly, the expressions need to be repeated like:


Of course, this assumes that the 2 expressions return numeric values. If they can be Null, you will need to handle the Null value also.