I have a report based off a query. The query includes a table field that is collected from a multilist on a form (e.g. check all that apply). The multilist is based off another table that includes an ID field and a value field (1 = value1, 2 = value2 etc).
The form shows the multilist values; the table stores the multilist value(s) selected on the form, the query shows the multilist value(s) from the table. However, the report displays the multilist ID (e.g. 1, 2) - not the actual value (value1, value2).
So two questions:
1. Why would this be, if the query is displaying the value?
2. How do I get the report to display the value, not the ID? Adding ".Value" after the field name in the control source still displays the ID, but in a separate record instead of bundled together in one record (so one record with value1 and value 2 selected would appear on two rows instead of bundled in the same row, which is what I want, along with the value to display)...
Thanks as always!
The form shows the multilist values; the table stores the multilist value(s) selected on the form, the query shows the multilist value(s) from the table. However, the report displays the multilist ID (e.g. 1, 2) - not the actual value (value1, value2).
So two questions:
1. Why would this be, if the query is displaying the value?
2. How do I get the report to display the value, not the ID? Adding ".Value" after the field name in the control source still displays the ID, but in a separate record instead of bundled together in one record (so one record with value1 and value 2 selected would appear on two rows instead of bundled in the same row, which is what I want, along with the value to display)...
Thanks as always!
