Ranking on Sales Data

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
 
V

Vichet Chea

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
 
Top