Record Ranking

From: Rachel (anonymous_at_discussions.microsoft.com)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 14:36:01 -0700

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