Another IIF question

[KenshiroUK]

I want to create a query that puts these countries into an ICS code Expr3: IIf([ship-country] DE, AT, BE,"CAI","ICS") however I do think there is something missing from this but not sure what. Could somebody help me please?


thanks.

 

[pr2-eugin]

Hello Ken, The general form of an IIf is as follows..

IIf( condition_to_check , True_part , False_part)

comma is the seperator.. if you wish to to have multiple conditions, then you have to seperate them with a logical operator as OR/AND/NOT.. If I remember correctly I asked you to design a table to add codes, so you can perform a JOIN.. but if this is how you wish to go, that's fine.. based on the general If condition would change to..

IIf(([ship-country]="DE" OR [ship-country]="AT" OR [ship-country]="BE"),"CAI","ICS")

 

[MStef]

Send a short example of your mdb, (Access 2000 or 2002-2003),
and say what you want to do.

 

[KenshiroUK]

It worked fine! I do have one more question though, how do I filter out GB orders? Is there a 'NOT' function for the query?