IIF syntax error (comma)

Blkblts

Registered User.
Local time
Today, 09:39
Joined
Jan 21, 2000
Messages
61
I have a report that contains a controlsource to employee the value is either T or F I set up an unbound field whose controlsource is IIF([Employee] = "T","Yes","No"). When I run the report I get
Syntax error(comma)in query expression [IIF([Employee] = "T","Yes","No")]. What am I doing wrong???

Thanks
kim
 
Sorry everyone. I built with query builder and like magic it worked....

kim
 

Users who are viewing this thread

Back
Top Bottom