Re: Record Ranking

From: MGFoster (me_at_privacy.com)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 21:58:40 GMT

There is an MS KB article to rank query results:

ACC: How to Rank Records Within a Query

http://support.microsoft.com:80/support/kb/articles/q120/6/08.asp 

-- 
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
Rachel wrote:
> Goal is to rank records in order of vendor bid.  Trying to get an 'AutoNumber' so-to-speak for each SKU in a group based on BID amount.  Any advice?
> 
> EX:  SKU           VENDOR           BID                RANK
>         A               AAA                $1                   1
>         A               BBB               $2.50                2
>         A               CCC               $5                    3
>         B                AAA                $4                  1
>         B                BBB                 $5                  2
> 
> Thanks!
> Rachel