|
View Full Version : Delete duplicate rows krishnarao 09-24-2008, 05:50 AM I have only one text column field in a table. I want to delete duplicate records i.e., if it has duplicate value, it should leave first record and delete the rest of the records. Is there any row number concept in Access?? Pls advice. Thanks in Advance. MSAccessRookie 09-24-2008, 06:01 AM I have only one text column field in a table. I want to delete duplicate records i.e., if it has duplicate value, it should leave first record and delete the rest of the records. Is there any row number concept in Access?? Pls advice. Thanks in Advance. Do you need to delete them, or would it be enough to ignore them? You can ignore them by doing something like this: Select DISTINCT TheField FROM TheTable krishnarao 09-24-2008, 06:22 AM No i want to delete the records! Rabbie 09-24-2008, 06:29 AM The simplest way is to base a Maketable query on the query given by AccessRookie. then delete the original table and rename the new table. krishnarao 09-24-2008, 07:10 AM Great! it worked for me... Thanks:) Rabbie 09-24-2008, 08:08 AM Happy to have been of help |