So the option group is:
1 - Newspaper
2 - Yellow Pages
3 - Yell.com
4 - Word Of mouth
5 - Thomson Local
I would look into the Switch() function. It can be used in a query or as the control source for a text box.
In a query, a column would look like
Code:
About Us: Switch([HearAboutUs]=1,"Newspaper",[HearAboutUs]=2,"Yellow Pages",[HearAboutUs]=3,"Yell.com",[HearAboutUs]=4,"Word Of mouth",[HearAboutUs]=5,"Thomson Local")
As a text box control source:
Code:
= Switch([HearAboutUs]=1,"Newspaper",[HearAboutUs]=2,"Yellow Pages",[HearAboutUs]=3,"Yell.com",[HearAboutUs]=4,"Word Of mouth",[HearAboutUs]=5,"Thomson Local")
This only one method of converting a number to text value.