J
janice.w
Have an Access data base which is added to monthly w/data
from an Excel spreadsheet (which was downloaded from a
mainframe query). Problem -- when new data is added the
pivot table treats the new month's data as though it were
foreign data, i.e. John Doe's data for month's Jan - Apr
are shown separately from his May data. However, queries
in Access seem to be treating all of the months' data the
same. The treatment of Any suggestions as to what is
going on would be most welcome.
from an Excel spreadsheet (which was downloaded from a
mainframe query). Problem -- when new data is added the
pivot table treats the new month's data as though it were
foreign data, i.e. John Doe's data for month's Jan - Apr
are shown separately from his May data. However, queries
in Access seem to be treating all of the months' data the
same. The treatment of Any suggestions as to what is
going on would be most welcome.