Report displays incorrect value

[AEH&H]

My report on a query does not display the query resulty. Result should be a
word "tune-up kit" (displays in query) and what shows is "14". The query is
on a table and the table value came from a look-up table. How do I get it to
display the description - I think It shows the ID#

 

[KARL DEWEY]

Open the query in design view and add the Look-Up table joined on the ID#s.
Drag the description down to the FIELD row of the grid and use it in your
report.