Deleting non-unique records (1 Viewer)

[gasbored]

I have imported a large number of emails into a table tbl_requests.

I had intended to have unique file tbl_requests.date_opened unique, but have ended up with a lot of duplicate records (i.e. tbl_requests.date_opened is not unique !). Any idea how to delete any duplicates? I have 15,000 records...

 

[pr2-eugin]

I did a simple Google Search, so many hits (in order of ease of understanding)

http://www.howtogeek.com/howto/micr...-access-to-find-duplicate-entries-in-a-table/

http://office.microsoft.com/en-gb/a...-duplicate-records-in-access-HA001034558.aspx

 

[gasbored]

Thanks, I had been seen some of those but had another lookk after your reply. I have got as far as creating a Delete query

DELETE [Copy Of tbl_requests].*
FROM [Copy Of tbl_requests] INNER JOIN qryUniqueDateOpened ON [Copy Of tbl_requests].date_opened=qryUniqueDateOpened.date_opened
WHERE ((([Copy Of tbl_requests].request_id)<>[qryuniquedateopened].[minofrequest_id]));


However, I get 'Could not delete from specified tables', in spite of the fact that I can manually delete from the table called '[Copy Of tbl_requests]'. Any ideas on this?

 

[Mihail]

Maybe this will help you:
Recordsets for Beginners - Access wiki - Access Help and How-to - Microsoft Office by UtterAccess.com