Text being stored as number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WM@TEN - 17 Feb 2006 20:35 GMT

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?

Reply to this Message

tina - 17 Feb 2006 20:51 GMT

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

> 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?

Reply to this Message