deleting records

[radicalrik]

I am trying to delete duplicate records, but keep the first record. Using the default duplicate records query doesn't work. It also pulls in the first duplicate record. i want to keep the first record, but delete all other duplicate records. Can anyone help?

[jzwp11]

Welcome to the forum.

If the records are true duplicates, then how do you know which is the first? Do you have a date field or an autonumber field where the data is different? If so, you can use that in the criteria of your query to select the correct records to delete.

[TheShabz]

Also, if they are true duplicates, what does it matter which one was first. They're both the same information no?