How can I delete duplicated records in an Access Query?
I need to delete duplicated records in an Access query and leave just one instance of each record. How can I do this?
Do you want to only show 1 record or actually delete it?
To delete the records open the table, delete records, go to design view and change the properties of the ‘PrimaryKey’ column to not allow duplicates.
If you only want one instance to show on reports-
I think this can only be done when you create a Report from that particular query. After the report is created, in design view, change the properties of the column you require to not show duplicates.
November 30th, 2009 at 2:07 am
You need to go to the original table on which the query is based, sort by whichever field is most appropriate and then delete the duplicates, or set up a delete query. However, if you have a proper relational database with several linked tables, it may be that you do not have duplicate records in your tables but have joined them incorrectly thus producing incorrect queries. Check the tables first though.
References :
November 30th, 2009 at 2:12 am
http://office.microsoft.com/en-us/access/HA010345581033.aspx
References :
Microsoft.com
November 30th, 2009 at 2:44 am
Do you want to only show 1 record or actually delete it?
To delete the records open the table, delete records, go to design view and change the properties of the ‘PrimaryKey’ column to not allow duplicates.
If you only want one instance to show on reports-
I think this can only be done when you create a Report from that particular query. After the report is created, in design view, change the properties of the column you require to not show duplicates.
References :