That's because you are using a Lookup in your table. This was transferred to
your query but not to your report.

The correct way to use lookups is in a combo box in a form.

But to rectify the problem.
Open your query in Design View

As a punishment for using a table Lookup Access gives you long, ugly
fieldnames that take you ages to type.

Find that field name - it may not be easy because it will probably have a
Caption to make it look cute in your query but its real name may be
something catchy like lookup_.to_TableWhatEver

You may have to click on the fields, click on the Properties button and
delete the Caption to find out the real name.

Delete the Lookup by clicking on the LookupTab in Properties and replacing
Combo Box with Text Box

Your nice text will be replaced, probably by an ugly number.

Press the Add Tables button.Add the Lookup table to the query grid. Add the
text field from the Lookup table to the query.

Open your report in Design View

click the Field List button

Drag the text field onto the report

Promise yourself that as soon as you have some hours to spare that you will
take control of your database and remove all your lookups and create nice
forms with combos to do the work.

Evi