deleting records

[prmitchell]

How do I delete specific records in a Clients where I know all the Client#s to be deleted, known from a query / a table made from the query.
So the new table has (called OldClients) Client#

so I want to delete all records in Clients where the client#s match between the Clients table and OldClients table

thank you in anticipation

 

[prmitchell]

thank you, but i think i have done this and I get an error Could not delete from specified tables

The (Access) SQL I have is
DELETE Clients.*
FROM Clients INNER JOIN [ClientsOld] ON Clients.[Client#] = [ClientsOld].[Client#];

so I still have the problem