Pivot table

G

Gianna

I am using a query to build a pivot table, one of my
fields is from a list box, when I look at in a report or
query it shows the text, but when I pull the data into a
pivot table it shows the ID or Key number assigned to that
item off of the list. Can someone please tell me how to
display the text?

Thanks
 
Top