Auto Ranking Reocrs based on sorted position

[Pele1]

I wrote a report in Access that will require sorting
records from a querry based on calculated field. The
problem I am having is I need to create a new field called
RANK that will use the position of each record to identify
the ranking for that record i.e first record in report
will show a RANK=1, second record will show RANK=2 etc.

Since the records in the database constantly change, I
will need the RANK field to be dynamic i.e. based on the
sorted position of the record as opposed to the value of
the field used in doing the sort.

Pele1

[Duane H]

To display an incrementing number in an Access report
- add a text box
- set its control source to =1
- set its running sum to Over Group or Over All

--
Duane Hookom
MS Access MVP

"Pele1" <zet...@yahoo.com> wrote in message
news:1098c01c27ea6$46faaee0$2ae2...@phx.gbl...

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.408 / Virus Database: 230 - Release Date: 10/24/2002