Query Issue

[joesmithf1]

Hi,

What's wrong with this code?: Employee:IIf(right(dedtype-Cd,1)='E'),'Employee','Null')

I am entering this in the Query Design View window.

MS Access error message says I have "the wrong number of argument."

Thank you.

 

[CraigDolphin]

Maybe the dash in your field name is fouling this up; also not sure about using the single quotes.

Employee:IIf(right([dedtype-Cd],1)="E"),"Employee","Null")

 

[boblarson]

There's one too many parentheses:

Employee:IIf(right([dedtype-Cd],1)="E","Employee","Null")

 

[joesmithf1]

Great! Thank you you guys!