Hi -
I am trying to delete duplicate records from a single table. The table has multilple records of duplicate purchase orders. In these instances I need to delete those records that have the same $amt but different qty.
I have already created the delete query but am unsure how to specify the criteria which should be based on the $amt and qty.
Simply said, I need the code to remove all Duplicates with the same $ but different qty.
How help would be greatly appreciated.