Delete duplicates QUERY

J

JohS

I'm having two tables, each with one field which contains some data:

___________

Table1

Field1

Per

Pert

Perte

Perter

___________

Table2

Field2

Pert



___________



Now, I want to make a DELETE Query in MS ACCESS 2003.

I go by the "Find Unmatched Query Wizard" (1st point on Table2, 2nd point on
Table1, 3rd click on Field2<=>Field1, 4rd point on Field2 to see. Then I
have "Table2 Without Matching Table1" (I then change Is Null to <>"False"
and show Table1.Field1 in stead of Table2.Field2)) I'll then end up with
this SQL:



SELECT Table1.Field1

FROM Table2 LEFT JOIN Table1 ON Table2.Field2 = Table1.Field1

WHERE (((Table1.Field1)<>"False"));



As I want to delete all the records in Table1 which has it's equals in
Table2, why can't I just change the word SELECT with the word DELETE,
without ending up with this ERROR MESSAGE:

"Specify Table containing the Records you want to Delete"


Thanks for help,

JohS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replace text with related number 1
Append Query ? 2
How can I quickly change the table name in a query? 15
Update or Append Query in Access 2003 2
message box 1
Query 1
fields in a select query 1
MS ACCESS query 5

Top