adding a null field to another field

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

Guest

I am doing caculation to find out the balance of two
field. Sometime one of the field may be blank...I have
notice that if zero is not in the empty field the field
calculating balance is blank. How can I correct this
problem
 
Use the nz function to create a zero if the field is null:

value = nz(myField,0)

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Use the Nz function, which returns the given second argument if the first
one is Null:

Total = Nz([Field1], 0) + Nz([Field2], 0)
 
Back
Top