AnsweredAssumed Answered

Duplicates - no first found

Question asked by CliveGoodall on May 20, 2011
Latest reply on May 20, 2011 by philmodjunk


Duplicates - no first found


Sorry if this has been answered before. I am a bit new to this. I have transfered a database from Lotus Approach. It is of a CD Collection. Fields:   title, artist, cd name, track no, date acquired. Many actual songs are duplicated – compilations, best ofs etc. Need to find duplicates by title and artist but not find the first instance of each. In doing this I can produce a listing of all songs by artist I have but avoid duplicating the same song by the same artist. Lotus had an inbuilt find that did this. Must be an easy answer but I can’t fathom it out. Thanks