Query Question

[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

 

[Jonathan Parminter]

-----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

Hi David,
use the Choose function...
create a new column with this as the field:

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

Luck
Jonathan