I use pivot tables to gather sales data from Access via MSQuery and display for all sales staff. I keep getting redundant data in a field. i.e. I have a column for periods 1 to 12 and currently am at period 7. For some reason I am recently seeing each prd number duplicated when I select the field for this column as if I'm going to supress data. I can supress the duplicates but why am I getting them? Anyone help?
This also happens if I had data for a specific area in say the Area column, which now no longer exists in the data within Access, but the pivot table still seems to think that the heading is still there, albeit with blank data.
This also happens if I had data for a specific area in say the Area column, which now no longer exists in the data within Access, but the pivot table still seems to think that the heading is still there, albeit with blank data.