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