Normaly, the field(s) that must not be duplicated should either be the primary key of the table (is there another primary key in your table ?) or having an unique index put on them, so that the table would not accept duplicated records (ie duplicated values for this field or group of fields)
For the moment, the best is to make a new table, empty, but with the same structure (same fields etc...). Then make a primary key on this new table (or unique index) with the field (or group of fields) that must not be duplicated. Then make an insert query (add records), adding the content of the old table into the new one. This should automatically eliminate records that have already been inserted in the new table (only the first one is inserted, the others are refused because they do not respect the primary key statement.) Then empty the old table and, with a new query, fill it back with the the records of the new one. Do not forget to put a primary key in the old table then so that the problem does not repeat ! GC -----Message d'origine----- De : [email protected] [mailto:[EMAIL PROTECTED] la part de loginmaryk Envoyé : lundi 12 septembre 2005 21:18 À : [email protected] Objet : [ms_access] Data duplications I have a MS database that calculates the commission for sales people, the branch managers provide me with the sales data and then database (query) calculates the commission. I have about 10,000 or more rows of data every month (in a table), the only problems that I have is sometimes branch managers duplicated the data by mistake for example we have two rows or more of data that are the same (the same Vendor # and Item #) is there anyway that I can make the query to eliminate the duplications. Thanking you in advance. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
