Hallo
I put the duplicated records in a new table. The next step is: "Is it possible to delete records with sql statement"? looking at table 1 for the id and delete in the data table?
Table1 has the id-number of the duplicate records. Table 2 contains the data. I try it with a delete query but it doesn't works!
thanks
annetiti
Last Activity: Sep 4 '12, 07:55 AM
Joined: Aug 30 '12
Location:
-
Duplicated rows in access table
Hallo
I want to delete duplicate records in an access table. There are more rows with the same data, only the id-nr is different. The table contains 96000 rows but not all the rows have duplicates. I try with a query but no result.
I send an extract of the table.
Can somebody help me!
thanks
Anne...
No activity results to display
Leave a comment: