delete records

J

JIM.H.

Hello,
I have table1 and table2, I need to write a query that
deletes all table1 records in table2.
How can I do that?
Thanks,
Jim.
 
M

[MVP] S.Clark

Create a query
Add table1 & table2
Link them by the proper field
Change the query to be a delete query.
Add a field from table2.
Set the Delete row entry for that field to read Table 2.
 
J

JIM.H.

Thanks Steve ,
It gave me can not delete table.
tabel2 is a link table, I am able to delete records throug
another query. What did you mean with "Set the Delete row
entry for that field to read Table 2.?
Thansk,
Jim.
 
Top