top ten and report

J

Jen

I have a Detailed report that I also need a summary on. The fields are as
follows
BranchName, UserName, Week'x'Orders, Week'x'SampleOrders, Week'x'SA%,
YTDOrders, YTDSampleOrders, YTDSa%

I need the Summary to list on the same report in separate groups:

The top ten UserNames (Week4sampleorders descending) from all branches.
The top ten UserNames (Week4sampleorders descending) from each of 7
individual branches in separate groups.

any ideas? I've tried queries based on sql I've seen for other applications
and get numerous errors - maybe I'm just not reading it right? Any help
would be greatly appreciated...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Top ten values in a report 1
Returning Top Ten in Report 3
How do I show the 'top ten' in an Access report? 1
Totaling Multiple Subreports 8
Need help setting up multiple columns in landscape report 7
Query the top top ten by category? 2
Ranking fields in a report 0
combining data from two unrelated tables in a report 1

Top