IIf statement that formats text?

[JackieEVSC]

I have a query that parses out apostrophe's in student names. In some instances, there is no student name. When that happens, the results are "#Error" for both FirstName and LastName. (Because I'm forcing the field to be included by way of joins).

The formatting for that field works unless there is no value ... LName: Replace([LastName],"'","").

If there is no name, I need the LastName field to pull in "Inventory", and the FirstName field be blank. If there is a name, I need to remove all apostrophe's from it.

Is it possible to do this with an IIf statement in a query?

Thanks in advance for any help you can give me!

 

[pbaldy]

Try

Replace(Nz([LastName], "Inventory"),"'","")