Delete Table Query issue

[cjjdavis2]

Hello All,

New to the forum officially, but have used this often to solve Access issues in the past.

I would like to remove records from a Table using a specific set of criteria...I've created a separate query containing all the criteria and now just need to remove records where they match.

Here's my SQL.

Any advice would be GREATLY appreciated.

Thank you in advance:
DELETE [Initial COBRA Sent].*
FROM [Initial COBRA Sent] INNER JOIN [No longer benefits elig_to remove from table] ON ([Initial COBRA Sent].[SEQ NUM] = [No longer benefits elig_to remove from table].[SEQ NUM]) AND ([Initial COBRA Sent].EMPLOYEE = [No longer benefits elig_to remove from table].EMPLOYEE) AND ([Initial COBRA Sent].COMPANY = [No longer benefits elig_to remove from table].COMPANY);

 

[BobMcClellan]

DELETE [Initial COBRA Sent].*
FROM [Initial COBRA Sent] INNER JOIN [No longer benefits elig_to remove from table] ON ([Initial COBRA Sent].[SEQ NUM] = [No longer benefits elig_to remove from table].[SEQ NUM]) AND ([Initial COBRA Sent].EMPLOYEE = [No longer benefits elig_to remove from table].EMPLOYEE) AND ([Initial COBRA Sent].COMPANY = [No longer benefits elig_to remove from table].COMPANY);

I would copy both tables before testing.... just to make sure it's doing what you want.
Then try DELETE [Initial COBRA Sent] From ....
as opposed to DELETE [Initial COBRA Sent].* From ....
hth,
..bob

 

[gemma-the-husky]

and hopefully, the query is updateable!