Giving a value to a null field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that has null values in the criteria field. What is the
correct expression to fill that field with the same value for all the records
in that result set?
 
To replace a Null with another value you can use the NZ Function

Nz([FieldName],0)
will retun 0 instead of Null

Nz([FieldName],1)
will retun 1 instead of Null
 
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

counting Null fields 3
Need null values for several fields in db 1
two null fields 4
Null or NOT in another table 4
#error - Blank 3
Testing for null 4
Filter out values of £0.00 in a query 3
Like is Null Query from Form 3

Back
Top