Null needs to be '0' (zero)

[jasonstewart]

I have a query that does a bunch of calculations and makes a new table with some columns having numbers and some have null I need the null fields to be zero. How can I do this ?

 

[WingandaPrayer]

Jason,

The Nz function should do it!!!!

 

[jasonstewart]

That may be the case, however I have never used it and it may be simple to you but having never been exposed to the Nz function I haven't any clue how to use it. I guess I will try to utilize this information. Thank you.

 

[Toga]

Lets say you have a variable named MyNum that your going to assign to another variable or insert it into a table and it cannot be Null.

OtherVariableName = nz(MyNum,0)

If MyNum = Null then assign 0 to OtherVariableName. Otherwise, assign the value of MyNum.

Check the help files for nz and it will give you other examples.