Hi All,
Apologies in advance if this is a) the wrong place to post and b) it's been solved - I've looked for 2 days and can't see anything - only how to hide duplicates.
I'm creating a spend reporting database that feeds data from excel into an access DB. The link works and the underlying data is correctly pulling through. However, the issue I have is that when trying to create charts, for whatever reason the charts ignore duplicate values which is not what I want. It messes up the data and means my report is useless...
I've tried looking at the indexes, filters etc and it's none of those. When I export the DB data to excel, the totals are correct so I know the data isn't the issue either!
Any help is much appreciated.
Apologies in advance if this is a) the wrong place to post and b) it's been solved - I've looked for 2 days and can't see anything - only how to hide duplicates.
I'm creating a spend reporting database that feeds data from excel into an access DB. The link works and the underlying data is correctly pulling through. However, the issue I have is that when trying to create charts, for whatever reason the charts ignore duplicate values which is not what I want. It messes up the data and means my report is useless...
I've tried looking at the indexes, filters etc and it's none of those. When I export the DB data to excel, the totals are correct so I know the data isn't the issue either!
Any help is much appreciated.