Making Null equal 0

R

Renita

I am running a query where I am adding two fields
together. Sometimes one of those fields is empty. How
do I tell it that when the field is blank to make it
a "0"?

Thanks for your time
 
D

Dirk Goldgar

Renita said:
I am running a query where I am adding two fields
together. Sometimes one of those fields is empty. How
do I tell it that when the field is blank to make it
a "0"?

Thanks for your time
Click to expand...

Use the Nz() function. For example,

CalcField: Nz([Field1],0)+Nz([Field2],0)
 
Top