Select case is possible inside Access SQL?

[vbSun]

Hi all,

I have something like this in the data. This data is returned by a query.

Code1 Code2
1 3
2 3
2 4

If Code1=1 and Code2=3 there is one description for that record. Code1=2 and Code2=3 there is another description and so on. The description of the above cases are hardcoded strings.

Now the question that got me stumped..

How can return the description from the query after scanning the data?

Thanks for all help.

------------------------------------------
The faulty interface lies between the chair and the keyboard.

 

[ZmrAbdulla]

Try thread701-1126133

________________________________________________________
Zameer Abdulla
Help to find Missing people
My father was a realistic father; not a vending machine dispense everything I demanded for!!

 

[vbSun]

Thanks for that response Zameer. Will try to play around with it.

------------------------------------------
The faulty interface lies between the chair and the keyboard.