Hello all,
I'm struggling to write the query bellow. Any suggestion are appreciated.
(Using Access 2013)
Sudo Code:
SELECT * FROM MYTABLE
WHERE COLUMN-A HAS COUNT > 1
AND COLUMN-B IS THE SAME
In other words, find the duplicates that have the same value for column-b.
Thanks!
Alex
I'm struggling to write the query bellow. Any suggestion are appreciated.
(Using Access 2013)
Sudo Code:
SELECT * FROM MYTABLE
WHERE COLUMN-A HAS COUNT > 1
AND COLUMN-B IS THE SAME
In other words, find the duplicates that have the same value for column-b.
Thanks!
Alex