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
 
Back
Top