mattster1010
04-08-2008, 08:46 AM
Afternoon,
I have a table in Access (2002) called Merge1 which is made up of three different fields, First_Name, Surname & Address_1. I have acouple of thousand records and many duplicates in the data. I wish to create a piece of VBA code that will always skip to the second record in the table and check that the First_Name, Surname & Address_1 data is not the same as the last record.
If the data is the same in ALL three fields as the last record then I want to delete the current record, if its not the same moving to the next record performing the check again...
Can anyone help / point me in the right direction please.
Cheers,
Mattster
I have a table in Access (2002) called Merge1 which is made up of three different fields, First_Name, Surname & Address_1. I have acouple of thousand records and many duplicates in the data. I wish to create a piece of VBA code that will always skip to the second record in the table and check that the First_Name, Surname & Address_1 data is not the same as the last record.
If the data is the same in ALL three fields as the last record then I want to delete the current record, if its not the same moving to the next record performing the check again...
Can anyone help / point me in the right direction please.
Cheers,
Mattster