if statement in access

[Guest]

I am currently writting a ledger for a business and on the tags that they
have in the store they have the cost in a a code (for example a=1, b=2 c=3)
and I am unsure of how to get this into access. Someone please help! TIA!

 

[Douglas J. Steele]

The best approach is to have a table that maps the codes to the costs, join
the two tables in a query and use the query where you would otherwise have
used the table.

Alternatively, you can use a nested IIf statement:

IIf(CodeField="a", 1, IIf(CodeField="b", 2, IIf(CodeField="c", 3, 0)))

or the Switch statement:

Nz(Switch(CodeField="a", 1, CodeField="b", 2, CodeField="c", 3), 0)