If Statement with multiple expressions?

[CatCity]

I am trying to create a zip code lookup for our database, to help place people in the appropriate town or county.
Currently, I am creating the If statements one by one, for example - IIf([Zip_Code]="97211","Portland","")

How can I create an If statement that allows multiple zip codes to return the result "Portland". For example, I would like my If statement to include the Zip code 97211, 97227, 97221 and return the result "Portland."

 

[DRSteele]

Welcome to the forum.

The simplest way is this: =IF([Zip_Code]={97211;97227;97221},"Portland","")

I suspect you'll have a need to look up all kinds of codes in a reference table of dozens of cities and their corresponding codes. Is that so?

 

[Joe4]

Welcome to the Board!

Since you posted this in the Access forum and mentioned IIF instead of IF, I assume that this is an Access question and not an Excel one (so the first response will not work for Access, as it is an Excel reply).

Basically, in Access, you typically would NOT use IIF statements for something like this. You would create a table with you link to to get your answer. Your table would have two columns - Zip Code and City. Your Zip Code would be your unique Primary Key. So then you would just link this table to your other table on the Zip Code field to return your City value.