Simple Help renaming fields

  • Thread starter Thread starter IAING
  • Start date Start date
I

IAING

Hi

I am a bit of a novice learning Access so could someone help.

I have a table which has a column of;

Eyes
1
2
3
1
1
1
1

1=blue 2=green 3=brown

In a query I can do =2 and bring up all the green ones.

What I would like to do is to change the 2 to be displayed as "green"
do not mind if thats in a separate column?

Hope I make myself unserstood.

IAI
 
Make a second table called EyeColors with two columns like this:

ColorID Desc
1 Blue
2 Green
3 Brown

Now, make your query like this:

SELECT Desc FROM EyeColor INNER JOIN MyTable ON EyeColor.ColorID = MyTable.Eyes

Cheers,
Pavel
 
Back
Top