zero instead of Null?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have to show outstanding quantities of deliveries for orders. There is no
problem if there was a partial delivery: outstanding=ordered-delivered. In
case of orders where there was no delivery at all, the field delivered
contains no value i.e. null. Accordingly the field outstanding has no value
either although it should show the quantity ordered. How can I solve this
task? Should I have zero in the field delivered, and if yes, how?

Thank u very much for your kind assistance.
 
Coldeyes said:
I have to show outstanding quantities of deliveries for orders. There is no
problem if there was a partial delivery: outstanding=ordered-delivered. In
case of orders where there was no delivery at all, the field delivered
contains no value i.e. null. Accordingly the field outstanding has no value
either although it should show the quantity ordered. How can I solve this
task? Should I have zero in the field delivered, and if yes, how?
Click to expand...


Just use the Nz function around the delivered field in the
expression:

Outstanding = Ordered - Nz(Delivered, 0)
 
Back
Top