Changing values in a query

[rowantrimmer]

In a query I am outputing a field called employee_number. If the field is blank (null) what would I put into the expression of the query to fill it in with say the value "10" ?

Help would be appreciated.

 

[TessB]

This is the field you would want to use.

EmpNo: Nz(employee_number, 10)

 

[TessB]

This is the field you would want to use.

EmpNo: Nz(employee_number, 10)

The above works with numbers only.
If you want to do the same for a string, as in your other post, it would be;

Surname: IIf ([Surname] is Null Or [Surname] like "", "", [Surname])