Query with expressions for use on form

[Guest]

I have created a query which sums payments applied to an invoice. A second
field gives the balance (Total - Applied). I inserted this as a subform on
my payment entry form so I can see open invoices. I see invoices with a 0
balance, but not the open ones with a balance. No criteria is set (or rather
I removed the <>0 I had on originally). Am using version 2003. Thanks.

 

[John Vinson]

I have created a query which sums payments applied to an invoice. A second
field gives the balance (Total - Applied). I inserted this as a subform on
my payment entry form so I can see open invoices. I see invoices with a 0
balance, but not the open ones with a balance. No criteria is set (or rather
I removed the <>0 I had on originally). Am using version 2003. Thanks.

If either field is null, the result of the expression
[Total]-[Applied] will be Null. Try

NZ([Total]) - NZ([Applied])

John W. Vinson[MVP]