M
Mr. Ed
I have a table (tblClients) that I imported from an Excel
spreadsheet. It is related to another table (tblCases) on one-to-one
basis. At this point there is exactly one record for each. The
problem is that tblClients has many records that have duplicates.
What I want to do is either do a find duplicates query using first
and
last name and have the duplicates removed and have the tblCases
updated to reflect the ClientID of the unique tblClient record that
is
remaining. Some of these have only one duplicate, many have none,
and
others have three or four depending upon how many cases they had. At
5000 records this spreadsheet was becoming unmanageable. Is there an
easy way to automate this?
spreadsheet. It is related to another table (tblCases) on one-to-one
basis. At this point there is exactly one record for each. The
problem is that tblClients has many records that have duplicates.
What I want to do is either do a find duplicates query using first
and
last name and have the duplicates removed and have the tblCases
updated to reflect the ClientID of the unique tblClient record that
is
remaining. Some of these have only one duplicate, many have none,
and
others have three or four depending upon how many cases they had. At
5000 records this spreadsheet was becoming unmanageable. Is there an
easy way to automate this?