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

microsoft.public.access.gettingstarted

23 Feb 2005 9:11 PM

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!

24 Feb 2005 2:42 AM

George Nicholson

ACC2000: How to Rank Records Within a Query
http://support.microsoft.com/default.aspx?scid=kb;en-us;208946
3 examples are included

--
George Nicholson

Remove 'Junk' from return address.

Show quote

"Heather" <Heat***@discussions.microsoft.com> wrote in message
news:F8C70ABB-4D2C-4936-B2A4-AC29C01594AF@microsoft.com...
>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!