Move duplicate values in a different table....

[jhargram]

HI All,

I have two tables with same column name in my ms access database. In one table i have some data with some duplicate values. I want to move only that duplicate values to another table.. exmp:

Table a Table b

column 1:name column 1:name
column 2:address column 2:address


Table "a" Data:

name	address
x	xxx
y	yyy
x	xxx
z	zzz

need one query to insert the duplicate row to another table.
After query run. It should be like:

Table a:

name	address
x	xxx
y	yyy
z	zzz

and Table b

name	address
x	xxx

Please help me to write this query or give me the solution.

[recyan]

Just check if below gives some guidelines :
Let us say, you have TableA

name	address
x	xxx
y	yyy
z	zzz
x	xxx

Chech below make table queries :
qryMakeTableAA

SELECT DISTINCT 
    TableA.name, 
    TableA.address 
INTO 
    TablAA
FROM 
    TableA;

and

qryMakeTableBB

SELECT 
    TableA.name, 
    TableA.address, 
    Count(TableA.address) AS CountOfaddress 
INTO 
    TableBB
FROM 
    TableA
GROUP BY 
    TableA.name, 
    TableA.address
HAVING 
    (((Count(TableA.address))>1));

Thanks