P
Petep
Hi,
Anyone tell me what is the problem with this query? I am trying to
delete duplicates out of a large table without re-creating the table.
When i run the inside "SELECT (MIN" subquery, it runs super quickly and
returns a table with the 200-300 records that would be duplicates as
I'd hoped. But when i attach the outer DELETE statement to the query,
Access suggests that it is processing the query, but even after 2 hours
it seems to have made no progresss (according to the status bar). The
whole application appears locked up and only a Force-Quit can bring it
back from the dead.
Any Thoughts?
DELETE * FROM tblServices WHERE
Record_ID In
(SELECT MIN(Record_ID)
FROM tblServices
GROUP BY DAT_Code, Service_No
HAVING COUNT (Service_No) > 1)
Anyone tell me what is the problem with this query? I am trying to
delete duplicates out of a large table without re-creating the table.
When i run the inside "SELECT (MIN" subquery, it runs super quickly and
returns a table with the 200-300 records that would be duplicates as
I'd hoped. But when i attach the outer DELETE statement to the query,
Access suggests that it is processing the query, but even after 2 hours
it seems to have made no progresss (according to the status bar). The
whole application appears locked up and only a Force-Quit can bring it
back from the dead.
Any Thoughts?
DELETE * FROM tblServices WHERE
Record_ID In
(SELECT MIN(Record_ID)
FROM tblServices
GROUP BY DAT_Code, Service_No
HAVING COUNT (Service_No) > 1)