Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying records with highest frequency in database 1

Status
Not open for further replies.

anjroid

Programmer
Nov 20, 2002
3
US
I am working on a search report for a database using Crystal Reports. What I would like to do is display the top 10 users who logged into the system. It would look something like this:

Username Number of times logged in

Smith00 9
Brown88 5
Joe2321 3

The information is read out of a Log table that records the username and other data everytime someone logs in. How can I do this? Would the TopN function work? Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top