If LastName null - use "vacant"

[EllieFant]

I am trying to create an expression in a query that will look at the LastName field and if it is null then put the word Vacant...if it isn't null (meaning a real person actually has that job) then I want the LastName Suffix, FirstName MiddleName to appear. I tried using the following statement but got a syntax error:

EmployeeName: iif(not isnull (LastName]), “Vacant”, [LastName] & [Suffix] & “, “ [FirstName] & “ “ & [MiddleName]

What do I need to change?

Thanks in advance for your help, Ellie
**Using Access 97 at work**
**Using Access 2000 at home**

lena.wood@starband.net

 

[ajdesalvo]

Try this:

EmployeeName: IIF(isnull([LastName]), “Vacant”, [LastName] & [Suffix] & “, “ [FirstName] & “ “ & [MiddleName])

Good luck! Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[EllieFant]

That worked...had to replace the " because doing the formula in word and then pasting it into access made the quotes funny and I think that was part of the problem.

Thanks for your help! Ellie
**Using Access 97 at work**
**Using Access 2000 at home**

lena.wood@starband.net