Access Data in Pivot Table Wrong

[dw1]

I have a table with a "Sites" field lnked from another database. In the table I have a lookup for the "Sites". I have linked the SITEID and SITENAME to create drop down combo box in the SITE field. The displayed data is the SITENAME but when I create a pivot table in Excel I get the SITEID instead of the SITENAME. How do I get the SITENAME?

 

[SMerrill]

Create a query that has both the ID and the Name in the same table. Bind the combo box to that query. If Pivot tables don't let you do this, then you'll have to ask this question on the Excel forum.