Query results

  • Thread starter Thread starter Dion
  • Start date Start date
D

Dion

I have a query where I have one field where a Transaction
Code may be either a 10, 11, 12, 13, 14, or 15. I am
trying to design a query so that those results will be
read and then give me GL code where 10=20, 11=21, 12=22,
13=23, 14=24, and 15=25. In the query, I have fields
named Tran Code and GL Code. I am trying to come up with
some sort of If statement where if a Tran Code is read
and then inserts the corresponding GL Code in the GL Code
field. Does anyone have any ideas on how I can accomplish
this? Below is what I want the outcome to look like:

Tran Code GL Code
10 20
11 21
12 22
13 23
14 24
15 25
 
SELECT TranCode AS "Tran Code", TranCode + 10 AS "GL Code"
From YourTable
Order by TranCode;
 
Back
Top