Print option results on a report

[Cecil]

I have a report that prints the records generated by a
Main Table. On the input form, I have an options group
that puts the results in the Main Table. However, as you
know, it stores the number of the option in the table, not
the actual label. (i.e. 1 = Option 1, 2 = Option 2, etc.)
So on the report, it prints the option group's number.
How do I go about having the report print the actual label
and not the number?

Thanks,

C.

 

[Allen Browne]

Presumably you have a lookup table that contains the meaning of these
options? If so:

1.Create a query to use as the RecordSource of your report.

2. In the query, include the lookup table.

3. Double-click the line joining the two tables. Access offers 3 choices.
Choose the one that says:
All records from my main table, and any matches from ...
(This ensures that records are not missed out where no option is chosen.)

4. Because the lookup field is now in the RecordSource of the report, you
can easily include it.

If you don't have a lookup table, you could use the Choose() function to
return the values.