delete records

[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.

 

[[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.

 

[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.