By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 997 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

C# - WINFORM : need help in counting data in Access database

P: 21
hi all,
im facing this problem and do not know where to start from.
Lets say i have this column called 'In-Charge".

In-Charge
John
John
John
Mary
David
Mary
Peter
David
John
Mary

given the example as shown above, by looking at it, i will know that the name "John" appears the most number of times. How do i get the value of the appearance count for each name and display only the top 3 appearance count? In this case it should be 1st = John, 2nd = Mary, 3rd = David. Appearance count will be John = 4, Mary = 3, David =2.

Please help, ur help will be greatly appreciated!
Thank You!!
Apr 19 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.