Query Criteria

F

Frustrated

I would appreciate any help with building an expression. I have a query and
one of the fields is an organization field. If the organization field is
blank I want the words 'Terminated' to replace the null value. Can someone
please provide the expression I need to use.

Thanks!
 
O

Ofer Cohen

Try

Select Nz([organization],"Terminated") As Neworganization From TableName

or, in another way. in the field section
Neworganization: Nz([organization],"Terminated")
================================
If the field is string, you might have empty Or Null, so you can try
Neworganization: IIF([organization]="" Or [organization] Is
Null,"Terminated",[organization])
 
Top