|
Home > Archive > MS Access database support > February 2006 > Pivot Table Help
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| jodyblau 2006-02-19, 3:24 am |
| 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
| |
| Ed Robichaud 2006-02-20, 9:24 am |
| 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" <jodyblau@gmail.com> wrote in message
news:1140322859.812581.216610@g44g2000cwa.googlegroups.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
>
|
|
|
|
|