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?

 

[WildHare]

You're probably getting SITEID because he's the bound column of the Combo Box - and you probably don't want to change that. So you'll need to alter your process a bit to deliver the contents of the UNBOUND column to Excel somehow. Without knowing the details, I hesitate to recommend an exact solution.

You refer to other columns in a combo box with a zero-based index. Col 1 in the combo is ComboName.Columns(0), for example, and col 2 in the combo is ComboName.Columns(1) and so on.

JMH

Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm

 

[GingerR]

write a query based on your table, making a join with the table of SiteID/SiteName. output the field SiteName instead of SiteID. use that query to go to excel.