Hoping for some help on Ranking within Access. I want to be able to rank pricing by "LaneID".
I have been able to rank the pricing with the below query, but I don't have any idea on how to differentiate the ranking by a single value, in this case "LaneID".
My first pass is below, it just ranks all records.
rank: (select count (*) from tbl:Respone_Pricing as T1 where [Charge] > [tbl:Response_Pricing].[Charge])+1
=================================
Desired Output:
LaneID--- Charge --- Rank
1 1.00 1
1 2.00 2
1 3.00 3
2 1.00 1
2 2.00 2
I created a seperate query to count the LaneID's. I'm stuck on what the next step would be or if I'm on the right path.
I have been able to rank the pricing with the below query, but I don't have any idea on how to differentiate the ranking by a single value, in this case "LaneID".
My first pass is below, it just ranks all records.
rank: (select count (*) from tbl:Respone_Pricing as T1 where [Charge] > [tbl:Response_Pricing].[Charge])+1
=================================
Desired Output:
LaneID--- Charge --- Rank
1 1.00 1
1 2.00 2
1 3.00 3
2 1.00 1
2 2.00 2
I created a seperate query to count the LaneID's. I'm stuck on what the next step would be or if I'm on the right path.
