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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#error - Blank 3
Adding the value of two fields when value is null 4
Query on two tables with matching null fields 4
cannot sum null; not zero 4
Testing for null 4
NULL isn't always NULL 2
eliminating criteria in a query 4
dynamic calculated field in query 3

Back
Top