Delete from another table

[momoko]

I have 2 table how can I delete records which is found in table 2.

 

[mrabrams]

It ain't pretty, but this is one way.

Run a "Find Unmatched" Query between the 2 tables based on the table's common 'unique' field.

Go into design view - Change Is Null to Is Not Null.

This produces the duplicate records. Delete these records.

(This is assuming the 2 tables have a )

HTH
Michael