Giving a value to a null field

J

JoeA2006

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?
 
O

Ofer Cohen

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
 
Top