Numbers not text in reports

P

Peggy

When a field in my report refers to a list box in a table
it gives the ID. number, first column, instead of the text
in the second column which is what I want.
 
T

Terry

Peggy,

The report is displaying what is stored in the table. You
will need to base your report on a query with the above
table AND the table that stores the text. The common join
field should automatically configure itself when you add
the second table. Use the text field from the second table
in your report.

HTH,

Terry
 
Top