Simple Delete Query

[philljp390]

This seems like a really simple query, and ive tried many ways to try and get it to work, but it wont!

Hopefully someone here can help. To put it simply this is what i want to do:

I have two tables:

Table1
1
2
3
4
5

Table2
1
2
3
4
5
6
7
8
9
10

I want to delete the contents of Table1 form Table2 so i would be left with:

Table2
6
7
8
9
10

How can i do this?

Thanks

 

[Rich]

Use the FindDuplicates query wizard then change it to a Delete query on the Toolbar

 

[philljp390]

Can u expand further? i just tried, and it didnt work.

 

[philljp390]

Its ok, theres actually an Unmatch Query Wizard i just found that works!!!

Thanks anyway