I believe our database is corrupted in some way and I am wondering how to fix it.

I am inserting pictures of a report that I have used for years and an excerpt of this year's report.

The rows in blue are correct. There is a royalty of 20%. But then the report intermittently pulls in the same product information with a zero royalty. Last year it duplicated one product. This year it has duplicated two and triplicated (if that is a word) four products. There are 184 lines on this report, most of which are correct so I don't think it is a problem with the report itself.

For this report, the totals are unaffected but it does make us question the integrity of the data! And whether anything is missing or not is undetermined. I don't think so but I can't be sure.

Any help would be GREATLY appreciated!!!!

Thanks, Leanne