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
 
Back
Top