Simple Delete Query

[Echo_3]

I'm not getting it and I know it must be simple.

I have two tables

Table1.................Table2
....109......................109
11871....................1321
20575..................71656
27800..................20575
............................27800

I want to delete from Table2 all the records that match Table1 but I get an error message that says "Could not delete from specified tables"

There is only one field in each table and their properties are identicle.

 

[cpod]

Just change the UniqueRecords property of the query to "yes".