Sorting Records

[Les]

I have a large number of records (over 200,000) in the following format

client number item sold
123456 description1
123456 description2
123456 description3

some records will have data repeated like so

client number item sold
123456 description1
123456 description2
123456 description1

I need to identify the client numbers where the description is repeatedand
only show the description which is repeated. I have run a find duplicate
records but that then shows all the client numbers and all the other
descriptions.

At the moment these records are in Access 2002 imported from Access 97.

Is there a simple way to do this.

Thanks

Les

 

[Ron Weiner]

Les

If I understand you correctly this query will show all of the customers that
had more than one of the same ItemSold.

SELECT Count(ClientNumber) AS [Num Dups], ClientNumber, ItemSold
FROM YourTable
GROUP BY ClientNumber, ItemSold
HAVING Count(ClientNumber)>1
ORDER BY ClientNumber, ItemSold;

Ron W

 

[Les]

Ron thats exactly right thanks.

Les

Les

If I understand you correctly this query will show all of the customers that
had more than one of the same ItemSold.

SELECT Count(ClientNumber) AS [Num Dups], ClientNumber, ItemSold
FROM YourTable
GROUP BY ClientNumber, ItemSold
HAVING Count(ClientNumber)>1
ORDER BY ClientNumber, ItemSold;

Ron W

I have a large number of records (over 200,000) in the following format

client number item sold
123456 description1
123456 description2
123456 description3

some records will have data repeated like so

client number item sold
123456 description1
123456 description2
123456 description1

I need to identify the client numbers where the description is repeatedand
only show the description which is repeated. I have run a find duplicate
records but that then shows all the client numbers and all the other
descriptions.

At the moment these records are in Access 2002 imported from Access 97.

Is there a simple way to do this.

Thanks

Les