I have a report that pulls data from a query. One of the fields in the query is called "Committees" and pulls from a lookup field in a table. The lookup allows multiple selections because many of the board members are in multiple committees. Also, this Committee lookup field pulls from a separate "Committees" table so that the company can add or delete committees within access if they need to and it will be reflected in the lookup selections.
In the table that the query produces this field is displayed correctly (ex. "Advisory, Finance, Hiring"), but when I run the report, it displays the ID numbers for each of these selections (ex. "2, 4, 7").

How do I correct this?... Thank you in advance

This became a problem when I made the "Committees" list an access table. The committees lookup used to pull from an excel spreadsheet because the people in the company were already using excel to keep track of the committees. I changed it to an access table because I figured it would be easier for editing (and potentially moving the database from computer to computer) to keep everything in access. This info may or may not help, but I found it peculiar that this problem arose only after I made the change...

Nevermind, I was able to fix it. The query that the report was using was pulling from another query. I had no reason to believe that that was part of the problem, but for the sake of trying anything and everything I decided to have the secondary query pull directly from the original table instead of the other query. This fixed things for some reason