I have created a query in access that appends data to a table. Once the data has been imported into the access table a pivot table is created based on the data contained within the table. However upon displaying the results in the pivot table the total of the values (that is the actual values that should be displayed) is doubled?
A delete query is run first to clear the contents of the table. And the 'sum' has been applied to the values?
Any ideas as to why the values would be doubled?
Thanks
A delete query is run first to clear the contents of the table. And the 'sum' has been applied to the values?
Any ideas as to why the values would be doubled?
Thanks