I am faced with a total of over 17000 duplicate records, most of which are similar to the attachment. In the process of assembling info, we had to pull from several sources, not all of which provided the same fields. Going back and starting the process over is not an option - we've been at this for 6 weeks.
How can I get these records to merge? If you look real close, I can copy the Desc to the fourth record and delete the first three. The goal is to end up with only one record.
Or maybe there's an easier way? Remember that these records don't always appear in this order.. and that other duplicated information exists in the table. This is just the most common situation at the moment.
Note: the second attachment is a more complex version of the problem, and should result in two records. Same problem, though - need to merge the lines properly.
Absolutely, just join both fields in your update query. Below is the SQL updating the Vendor from Sample2 to tblYourTable:
UPDATE YourTable INNER JOIN Sample2 ON (YourTable.PackNo = Sample2.PackNo) AND (YourTable.Description = Sample2.Description) SET YourTable.Vendor = Sample2.Vendor
WHERE (((Sample2.Vendor) Is Not Null));