Access SQL Query - Compare & Identify 2 columns in same table

[Nowherefast]

Hello All

I am trying to compare and identify 2 columns within the same table to output which UPC's have more than 1 occurrence in UniqItem field

For example

UPC UniqItem
5555555555 333222
5555555555 333222
5555555555 333222
3333333333 000001
3333333333 000001
3333333333 000002
3333333333 000001

The query should result in

UPC UniqItem
3333333333 000001
3333333333 000001
3333333333 000002
3333333333 000001

I've been working on the following Query but nothing comes out

SELECT UPC, UniqItem
from [ItemTable]
group by UPC, UniqItem
having min(UniqItem) <> max(UniqItem);

What am I doing wrong?

Thank you

 

[Joe4]

Try this:

SELECT UPC, UniqItem
FROM ItemTable
WHERE UPC In
(SELECT UPC
FROM ItemTable
GROUP BY UPC
HAVING Min(UniqItem) <> Max(UniqItem));

 

[Nowherefast]

This worked perfectly MrExcelMVP....thank you so much!!!!

 

[Joe4]

You are welcome!