Writing 'IIf' query

[camelk]

I need help writing an 'IIF' query. The field in my table is 'Title' and the person receives a '1' if an M.D. or '2' if a D.O. When I query the table, I want 'M.D' and 'D.O.' to show-up in the query, not '1' and '2'. I wrote:
Title: IIf([tblPhy]![PhyTitle]=1," M.D."," D.O.&quot but received #ERROR when the query ran. Help!! Thanks
camelk

 

[tlbroadbent]

Try using a . rather than !. Make sure the table and column name are spelled correctly.

IIf([tblPhy].[PhyTitle]=1,"M.D.","D.O.&quot Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[camelk]

Terry,
I'm still getting the #ERROR msg. Any idea why?
camelk

 

[tlbroadbent]

No idea. Can you post the entire query please? Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[camelk]

Terry:
It's a very long query (25 flds). I'll just keep playing aroung with it. Thanks for your help.
camelk