Cheers for the help so far, this is where am up to. I can select the items that are duplicated but when i try to select all 3 fields from my table it dosen't work.

Here is my query

[sql]SELECT Torder_NO, TPart_NO
FROM dbo.TestingGSS
GROUP BY Torder_NO, TPart_NO
HAVING (COUNT(*) > 1)[/sql]

But I have a column called TOrder_Qty that i want included in the results but it shouldn't affect the crietria of the query. So far I have tried this numerous ways and it dosen't work.


Cheers for any help