getting an ID number instead of name on report

[Guest]

I am using a reference table to populate a field on a form that works well.
The ID Name appears when selected. When I use it on a report I get the ID
Number instead of the ID Name. What do I need to do to get the ID Name to
appear in the report.

Thanks in advance to your help and advice.

 

[Allen Browne]

Create a query to use as the RecordSource for your report.

The query will contain your main table, as well as the lookup table. That
means you can get the ID Name from the lookup table into the report.

If some of the records in your main table have no value for the lookup
field, make sure to use an outer join between the 2 tables in the query.
Details in the 2nd part of this article:
http://members.iinet.net.au/~allenbrowne/casu-02.html

 

[Guest]

Thank you so much for replying to this post. I did create q query for the
form. Could I use that same query on the report?
Thanks again!

 

[Allen Browne]

Sure: if the query returns the name from the lookup table, then there should
be no trouble in putting that onto your report.

1. Open the report in design view.
2. If you don't see the Field List dialog, click Field List on the View
menu.
3. Drag the field from the Field List to where you want it on your report.