Option group values showing as the words in reports

J

JudyT

Hi,
Can anyone tell me how to make my options in the option group show in my
reports.

I have this as the options:
1=Sat
2=Unsat
3=Nonparticipant

Thank you
 
A

Allen Browne

Create a table with 2 fields: a Number field (contains the 1,2, etc), and a
Text field (contains the Sat, Unsat, etc.)

Create the relationship between your main table and this new lookup table
(Relationships on Tools menu.)

Create a query that uses your main table, and this new table. Include the
text field in the fields shown by the query.

Set the Record Source of the report to the query. You now have the text
field available to display in your report.
 
Top