Hi there
I am trying to make an update query that will update information in all occurances of duplicate records based on the First record for that duplicate set.
There are about 30,000 records in the table, and of them without the duplicates there is only about 4000 records.The duplicates are essential to work we do, so we cannot delete them.
I have a make table query that selects only the first record...
bcquadrant
Last Activity: Feb 11 '08, 02:40 PM
Joined: Sep 24 '07
Location:
-
Duplicates Updates Query
-
I really appreciate your replies, and thank you.
I guess im not really explaining myself that well am i, heheh.
I am currently in the process of converting an excel spreadsheet (which we currently work out off) into an access db, unfortunately the only thing holding me back is the duplicates. Daily imports from an external source means more duplicate records, and updating those records is a required step in the import... -
Hi,
Basically, I pretty much want something to run through the 30,000 records, identify an MPAN and update its duplicates, then move onto the next MPAN and do the same.
I thought about using more than 1 table to do this, such as a "Child" and "Main" as Steve said, but we have to do new imports everyday and that again causes more duplicates. So one way or another, since we need them, it needs something...Leave a comment:
-
Updating All Duplicate Records
Hi there,
I hope someone can help me with my problem,
I have a database with about on average 30,000 records in, and most of them are duplicates, however the duplicates are required for the work we do, as each represents a different payment, but only 1 action is required.
What I need is a button than you can press and it will go through the entire recordset and will update all the duplicate records and...
No activity results to display
Leave a comment: