Replace a number with a word in a query

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

DavidW

I have got a query that has got a field named "type" that has the numbers 1
and 2 in it.
Is there a way to start a calculated field and get it to change the numbers
to a word like
if [type] =1 then [whatever]=active
else
[whatever]=dismissed

Not very good at SQL Statements Yet
Thanks
David
 
Back
Top