Text being stored as number

[Guest]

I have a field that is a text field in both tables I am running a query from.
When I try to put it in a pivot table, it is displayed as numbers (ID) How
can I get this to display my order name?

 

[tina]

are you sure the fields are a Text data type in the tables? sounds like
they're Lookup fields. if that's the case, then you've run into one of the
reasons that many experienced developers NEVER use Lookup fields in tables -
they disguise the data that's actually being stored in the field, and cause
confusion and other problems in forms and queries. suggest you get rid of
the Lookup fields in the tables. in the query, add the linked table that
provides the Order Name (tblOrders, perhaps?). drag the Order Name field
into the query grid.

hth