How do I number and rank records in Access, based on another field

H

Heather

I am trying to rank the records in my Access database based on a field which
contains the sum of other fields. I need them to be ranked in order from
greatest to least and I need the ranking number to be returned (displayed) in
a separate field. I know how to sort the records. However, I cannot figure
out how to assign a numberic value to the ranking.

Any input would 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

Detemine sales order based on plac changes and not sales figures -mathmatic problem to solve 1
Autonumber field in Excel that behaves the same as Access 0
Finding the right style field in VBA 0
Copy previous record into form field 0
Rank and row number in Access? 3
RANK - dont include zeros 5
Finding the proper style field and the numbered paragraph value within the style 0
Automation of scanned file storage based on content 0

Top