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

 

[Pat Hartman]

Back up the database.
Make copies of the two tables involved just in case.
Create a query that joins the two tables.
Drag the * for the table from which you want to delete rows to the grid.
Change the query type to Delete.

 

[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

 

[Pat Hartman]

Try adding a primary key to the ClientsOld table.