I can't seem to figure out how to gather a found set of the records I need displayed...???
Posted on 2007-08-06
I have a table called Auctions that has both an ItemNumber and a ScanID in it. ScanID's are unique to ItemNumber's, so if I have 10 auction records with the ScanID 12345 they should all have the same ItemNumber.
Somehow I've gotten lots of auction records that are getting incorrect ScanID's. I need to figure out how, but right now I simply need a way to find all of the problem records.
I can put a ! in the ScanID in Auctions to get a found set of records with duplicate ScanID's, however, I don't know what to do from there in order to filter so that I only see records with duplicate ScanID's but different ItemNumber's.
Any information would be greatly appreciated. Thanks!