Could you reply with your full sql statement? Are the quote marks true quotes
or some other variation? Your reply states:
“Other”,
where I would expect:
"Other",
Notice the difference?

--
Duane Hookom
Microsoft Access MVP


"pushrodengine via AccessMonster.com" wrote:

I get the following error:

Syntax error (missing operator) in query expression ‘CallDtl: IIf(IsOther,
“Other”, tblIncidentLog.[CallDetail])’.

--
Message posted via http://www.accessmonster.com