iif syntax help needed

[mattc66 via AccessMonster.com]

Below is how I have the iif statment in my query. Its not working.

WHSE1: IIf([whse]="1B","WDNVL",IIf([whse]="2C","COKATO"",IIf([whse]="2M",
"NOVI")

Basically I need the following
If whse = 1B then display WDNVL
If whse = 2C then display COKATO
If whse = 2M then display NOVI

When I run the query it doesn't display the Cokato or Novi names they are
blank.

 

[Roger Carlson]

You've got two quote marks after COKATO. There should be only one.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[mattc66 via AccessMonster.com]

After I sent the posting I noticed that. Thanks it is working now. Darn
Typo's get me every time.

You've got two quote marks after COKATO. There should be only one.

Below is how I have the iif statment in my query. Its not working.

[quoted text clipped - 8 lines]

When I run the query it doesn't display the Cokato or Novi names they are
blank.