translate/decode

[MAH]

I am trying to figure out how to do a decode(sql) in access. I want to look
at one column of the table and based on the result pull another column.
example:
decode(acct_period,'200412',trans_amount,0)

I have tried IIF and choose with no luck.

Any help would be appreciated.

 

[Van T. Dinh]

Check Access (VB) Help on DLookUp() function.