option group: help with numeric values

[dbertanjoli]

Hello,
I am not sure what cateogory to choose for this question but I would greatly appreciate your help.

I have 5 buttons in my option group:
1. very often
2. often
3. occasionally
4. rarely
5. never

I have to produce a report using description of each button in my report, not numeric value. I heard something about global variable but I am not sure how to do it.

Many thanks,
Debbie

 

[Dennisk]

there are a number of ways to acomplish this task. Probally the easiest is to create a table with the numeric value and description and link that to the query for the report. However this begs the question why not use a combo box in the first place as it only requires a new entry in the table instead of an amendment to the form.

Other ways include using IIF statements in a query or a select Case statement in the reports on print event.