IIF len

[slimjen1]

All, using access 2010, I'm trying to use len in an IIF statement:

Type: IIf(Len([qryMaster].[PAYROLL])<3,[”Active”],["CLIENT”])

When I run the query; it puts brackets around "Active" and "Client" and it doesn't return any values.
What am I doing wrong please.

 

[Ranman256]

Remove the brackets.
Brackets mean fields.
If you WANT fields, remove the quotes.

 

[slimjen1]

this is what I'm saying; it automatically puts brackets around the name I put in quotes. If I remove them; it comes back.

 

[slimjen1]

I got it. I just retyped it. I was copying the code and it didn't recognize the "". Thanks