By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,478 Members | 1,601 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,478 IT Pros & Developers. It's quick & easy.

Pivot Table Help

P: n/a
I am attempting to learn to use pivot tables.

I have noticed that if I have used the Lookup Wizard when creating my
tables so allow the user to select from a list of choices when entering
data, this causes a problem with the pivot tables.

When I try to use a field like "Customer_Name" and drag it onto my
pivot table, it display's the ID for that Customer instead of the
Customer's name.

Is there a way to change the pivot table so that it will display the
name rather than the ID in this situation?
Thanks,

Jody Blau

Feb 19 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Your lookup/find combobox is probably showing the CustName but really
operating on CustID. Look at the properties of the combobox and you'll
probably see that the 1st column (CustID) is set to 0" width (to hide it).
Make the recordsource of your pivot table a query that contain the actual
CustName as well as the ID-Name lookup.
-Ed

"jodyblau" <jo******@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
I am attempting to learn to use pivot tables.

I have noticed that if I have used the Lookup Wizard when creating my
tables so allow the user to select from a list of choices when entering
data, this causes a problem with the pivot tables.

When I try to use a field like "Customer_Name" and drag it onto my
pivot table, it display's the ID for that Customer instead of the
Customer's name.

Is there a way to change the pivot table so that it will display the
name rather than the ID in this situation?
Thanks,

Jody Blau

Feb 20 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.