select Complaints.RowID,Complaints.ComplaintID,Complaints.BarCode,Complaints.CustomerReason,Complaints.AdjudReason,State from Complaints right join (
select BarCode From Complaints Group by BarCode having Count(BarCode) > 1 ) T on Complaints.BarCode = T.BarCode
select BarCode From Complaints Group by BarCode having Count(BarCode) > 1 ) T on Complaints.BarCode = T.BarCode