Duplicates

[Robin Hood]

Hello,

I have managed make a table of approx 150,000 duplicate telephone numbers which have donated to the charity I work for over a number of years. Some have donated 2,3,4 or 5 times over the years. Is there a way to find out how many people have actually donated more than once. Also to break down the data to find out how many have donated twice, three times and so on. I am using Access 2000.

I hope someone can help

cheers

Robin

 

[MSAccessRookie]

Hello,

I have managed make a table of approx 150,000 duplicate telephone numbers which have donated to the charity I work for over a number of years. Some have donated 2,3,4 or 5 times over the years. Is there a way to find out how many people have actually donated more than once. Also to break down the data to find out how many have donated twice, three times and so on. I am using Access 2000.

I hope someone can help

cheers

Robin

You can try a Query that Counts the number of records, Grouping By the Telephone Numbers

Select PhoneNumber, Count(*) 
From YourTable
Group By PhoneNumber

If you need the Counts grouped as well, try adding an Order BY Count(*) after the Group By Statement.