AnsweredAssumed Answered

Eliminating duplicates

Question asked by hwdavy on Jan 18, 2010
Latest reply on Jan 19, 2010 by RSchaub

Title

Eliminating duplicates

Post

Mybrother-in-lawsellssmallmilitaryequipment (resistors, capacitors) andhasadatabaseof65,000records. Hedoesn'tknowalotaboutdatabasecapabilitiesHehasenteredtheoriginalpartno. inthepartno. fieldand, ifthe  producthasone, enteredanalternativepartno. inthealternativepartno. fieldThen, tobesuretofindit, heenteredthealternativepartno. inthepartnofieldandthepartno. inthealternativepartno. fieldAnd, ofcourse, addedcostandretailpricetoeachentry.

 

Isthereawaytoeliminateallofthealternativepartno. inthepartno. fieldsothatthereisonlyoneentryforthatpartanditscostandresalevalueHehas17,000duplicateentriesinhisdatabase.

 

Hwdavy

Outcomes