I have a Table that stores data inputted from a Form (Option Group) as a number. For example:
This data is eventually moved to (displayed) in a Query. What I'd like to do is change how this data is represented in the Query. I'd like to change the data from a number to specific text. For example:
1 = Red
3 = Black
4 = Brown
I'm sure this is a softball--but I just cant remember how to do it. Can anyone give me instruction as to how to make this happen?