Sorting in reports

[Rich Stone]

Sorry the subject is a bit vaugue!

Basically, I have a spreadsheet listing clients and their visits to my
workplace. I need to find the top 10% for times visited. To start with, I
have inported the spreadsheet into Access 2003 and produced a report that
groups each client using the sorting/grouping method and so I am able to get
a list with each client listed once and the footer of each group shows a
count of their visits. However, I am now stuck as to how to sort these
clients into the order of most visited.

Any ideas would be extremely helpful! Thanks in advance...

Richard

 

[a a r o n . k e m p f]

SQL Server Reporting Services allows you to have 'interactive sorting'
in your reports

it doesn't take any coding.. it doesn't require another call to the
database server

Thanks

-Aaron