468,467 Members | 2,686 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,467 developers. It's quick & easy.

Pivot Table Help

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
1 1697
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.

Similar topics

2 posts views Thread by Rob | last post: by
3 posts views Thread by Jerry K via DotNetMonster.com | last post: by
9 posts views Thread by PeteCresswell | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.