Ranking

[elgoober]

Hi

I have a table that contains several thousand records detailing
PartNo, Price and Customer.

I want to do a query that ranks the price for each part number

so say

Part Price Rank
a 1 1
a 10 2
a 100 3
b 1 1
b 10 2
b 100 3

I'm stuck at the part number break.

Any ideas much appreciated

Cheers

 

[pbaldy]

However you're doing the ranking, add part number to the criteria. Post your current method if you're still stuck.