Query - Pivot Table

[Guest]

Every month i update a query with new fields as new monthly data has come in.
I create new fields based on the previous months results due to the format in
which the data comes in.
However, once I have created these fields, they then do not show up in the
related pivot table field list and i do not have the option to add them in to
the pivot table.
Does anyone know why this is?
Many Thanks,
Matt

 

[Guest]

Your problen is that you are renaming the fields. You need to get your data
into a table where the field names are generic enough so that they won't
change. You can acheive this by creating an import macro that populates the
same table all of the time.