If statement in query - criteria help!

[fluffyvampirekitten]

I have a table of Duplicates data .




ID | Name
1 | Teddy
1 | Ted
2 | Ben
2 | Ben
3 | Pinky
3 | Pinky

I would like to extract the data which have different Names but have the same ID
Result:

ID | Name
1 | Teddy
1 | Ted

Any idea to do it in a query or vba ?

if id = id
if name != name
display data
else
do nothing
end if
else
do nothing
end if

[orange]

I made up the table name tblPeeps, and since Name is a reserved word in Access I used pName.
This should give you a good start.

SELECT count(tblPeeps.ID), tblPeeps.pname
FROM tblPeeps 
group by pname
having count(tblPeeps.ID) <2

[fluffyvampirekitten]

I made up the table name tblPeeps, and since Name is a reserved word in Access I used pName.
This should give you a good start.

SELECT count(tblPeeps.ID), tblPeeps.pname
FROM tblPeeps 
group by pname
having count(tblPeeps.ID) <2

Omg. Thank you so much