NULL -zero

[Lasse T]

Hi!

I have a simple calculation in a form.

=[val1]-[val2]-[val3]

Val3 can sometimes be null and when that happens the result is also null.
How can I make Access treat the null value as zero?

Lasse T
--------------

 

[Cheryl Fischer]

Check out the NZ() function in VBA Help, Lasse.

 

[Rolls]

.... - nz([Val3],0)

You may encounter problems with datatypes along with nulls, so check out
string and numeric conversion functions as well.