access vba - Acess Intermediate

Hi Perveen

If the target table has different field names you need to reset the field names in the query.

You do this by going to the field in the query that needs to be changed and adding the name folloed by a colon.

So if the current name is Description and the required name in the new table is Product_Name then this is how it would appear in the query:

Product_Name:Description

When you now run the pivot table the new field name appears.

Hope this helps

Carlos