Full name in table to abbreviation in query

[pldm123]

Hi all,

I have a table populated by a form where the user enters the country and state/province (complete names) as an account information. The user can enter up to 2 accounts for each case.

Later in the process, I am using a query to get information from that table. However, I would like the query to output the country and state abbreviation instead of a full name. Only one of the two accounts is displayed using a iff statement.



"Country: Iff([Type]="Type1";[AdrCountry_1];Iff([Type]="Type2";[AdrCountry_2];""))"

I created a "full name - abbreviation" table.

What do I need to add to the query (as of now my output is the full name) to get the abbreviation?

Thank you very much,

[ranman256]

instead of nesting Iif statements, try the easier SWITCH function

country: Switch( [Type]="Type1", [AdrCountry_1], [Type]="Type2", [AdrCountry_2])