How to get the Oracle's Decode Functionality in MS Access

Hi,

I need the Decode Functionality of Oracle in MS Access... I have a field with four values and I have to display as 1,2,3 and 4 for that instead of A, B, C and D..


Pls. send the code ASAP..

Regards,
Raja

The easiest thing to is create a new table where you store the following

Field1,Field2
A,1
B,2
C,3
D,4

You your write a join between the other table and this table and dispaly field2 where field1 is equal to you field in the other table.

OR

use VB Code and use the

Value1 = Replace(Value1, "A", "1")

S-