J
janice
I am updating an access data base periodically with
imported data from Excel. I then do a pivot table in
Excel which imports the info in the Access data base.
(Too much data to keep it all stored in Excel)
The problem I am encountering is that the data will at
times appear in duplicate in the pivot table.i.e., the
options on a drop down are shown in duplicate -- if
Supervisor is an option in the Employee Title field the
word "Supervisor" will appear twice, exactly the same, in
the drop down. The added months data shows up in the
second option of Supervisor, the first four months would
show up in the first option Supervisor. The only way I
can fix it is to do a query in Access for all records
where Employee Title = Supervisor and replace Supervisor
w/Supervisor. Then the second Supervisor option is gone
on the drop down in the pivot table after I refresh it.
Any ideas as to what is causing this duplication?
imported data from Excel. I then do a pivot table in
Excel which imports the info in the Access data base.
(Too much data to keep it all stored in Excel)
The problem I am encountering is that the data will at
times appear in duplicate in the pivot table.i.e., the
options on a drop down are shown in duplicate -- if
Supervisor is an option in the Employee Title field the
word "Supervisor" will appear twice, exactly the same, in
the drop down. The added months data shows up in the
second option of Supervisor, the first four months would
show up in the first option Supervisor. The only way I
can fix it is to do a query in Access for all records
where Employee Title = Supervisor and replace Supervisor
w/Supervisor. Then the second Supervisor option is gone
on the drop down in the pivot table after I refresh it.
Any ideas as to what is causing this duplication?