I am working on some code to delete duplicate records where someone has moved from one insurance plan to another it will show the most recent plan (has to be open ended date, would have an end date of <>"00000000") , I can't just delete records of everyone that does not have an end date of <>"00000000"; it has to be the records that are duplicate member numbers. If someone was covered through the end of the month ( i. e. they left the company) they need to be accounted for. I created a new table to populate with duplicates called "CelMemId".
I ran this code:
DELETE FROM CovElig b
WHERE b. MemberId in
(SELECT distinct CelMemId. MemId
FROM CelMemId, CovElig a
WHERE CelMemId. MemId = a. MemberId
AND a. EndDt_mem <>"00000000");
And this delete query has been running since yesterday afternoon (about 20 hours) without finding any records. I believe that this could be an Access issue. . . that Access just cannot handle all the data that is in our database. We are currently programming our database in Access but will be moving the SQL code over into an Oracle Database in the Fall. Thanks for any help with this issue.