Query Question

  • Thread starter Thread starter DavidW
  • Start date Start date
D

DavidW

Can you take a fields number, and add a field in a query only(not in the
table), and change that number to text in the field that was added to the
query
I am not very good at SQL
example
if advtype = 1
then 1 would equal Gas
if advtype = 2
then 2 would equal offroad
if advtype = 3
then 3 would equal onroad
 
-----Original Message-----
Can you take a fields number, and add a field in a query only(not in the
table), and change that number to text in the field that was added to the
query
I am not very good at SQL
example
if advtype = 1
then 1 would equal Gas
if advtype = 2
then 2 would equal offroad
if advtype = 3
then 3 would equal onroad
Click to expand...
Hi David,
use the Choose function...
create a new column with this as the field:

Adv:Choose([advtype],"Gas","offroad","onroad")

Luck
Jonathan
 
Back
Top