Making Null equal 0

  • Thread starter Thread starter Renita
  • Start date Start date
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
 
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)
 
Back
Top