Option Buttons

[Cyber27uk]

Access 2007



I Have a customers table and within that table a field called 'hearaboutus' (data type - Number). From this table I have a customers form and on this form an option group with 5 option buttons:

Newspaper
Yellow Pages
Yell.com
Word Of mouth
Thomson Local

The control source for the option group is 'hearaboutus'

Is it possible to some how display the information contained in 'hearaboutus', may be in a graph?

Thanks for your time

Mark

[ssanfu]

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

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:

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