Ranking on Sales Data

  • Thread starter Thread starter chuckW
  • Start date Start date
C

chuckW

Hi,

I am running a report that sum the top customers for our
sales organization and have sorted in descening order
based on revenue. This allows the best customers to be
placed first. I want to have my query or report then add
a field which ranks them. I am building an application
with Access Forms that will run this query and put the
results on an Access report. Anyone know how to do this?

Thanks,

Chuck
 
Only Possible on Report
- put textbox on the report, and set countrol source to =1
- set Running sum to whatever you want: Over Group is to rank or sum only in
the group you place textbox, Over All for the whole report
 
You must log in or register to reply here.

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

Detemine sales order based on plac changes and not sales figures -mathmatic problem to solve 1
Access MSACCESS - Sorting report based on field calculated in the report 0
Creating Top 10 in linked subform 1
Sales Ranks 1
Event item sales 1
Ranking Customers based on Total Sales 2
TOP Query - Slow Performance 2
Rank a Rank? 1

Back
Top