Grupos de Google ya no admite publicaciones ni suscripciones nuevas de Usenet. El contenido anterior sigue visible.

Auto Ranking Reocrs based on sorted position

2 vistas
Ir al primer mensaje no leído

Pele1

no leída,
28 oct 2002, 12:20:14 p.m.28/10/2002
para
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

no leída,
28 oct 2002, 6:46:24 p.m.28/10/2002
para
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


0 mensajes nuevos