Record Ranking

[Rachel]

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 RAN
A AAA $1
A BBB $2.50
A CCC $5
B AAA $4
B BBB $5

Thanks
Rachel

 

[MGFoster]

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