Query with expressions for use on form

M

m stroup

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.
 
J

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.
Click to expand...

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

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

John W. Vinson[MVP]
 
Top