adding a null field to another field

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
 
A

Adrian Jansen

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
 
G

Graham Mandeno

Use the Nz function, which returns the given second argument if the first
one is Null:

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