Unanswered: Option group displays numeric values in report
I have an option group on my form and the default numeric values are being stored in the table. My report is displaying the numeric values. How do I get it to display the text values associated with each number?
Problem is , I have a table where the option values are being stored as numbers. Then I made a lookup table where the option values are associated with text, then joined them in a query expecting to use the query in the report. Then when I tried to use both the table and the query as source for the report, I got an error saying I couldn't use data from both the table and the query because the table was being used *in* the query. ??!!! That's the whole point. I need the table values translated by the query to retrieve the text values.
As for the second suggestion, I can't use a true/false immediate iif statement because there are too many options (six), so I tried the nested iif statement. My expression was the following ("status" is the field on my table, and using dummy text to save time):
I think the syntax is correct, but I get "#error" showing up in the report. I'm placing the formula in the "control source" of the properties box for the field on the report. Is that where I'm supposed to put it?