Rank Totals based on a query

[mattc66 via AccessMonster.com]

I am trying to do a Ranking of Sales totals. I am not sure why the below is
not working. Can you rank based on a query that runs a grouping?

Thanks
Matt

SELECT qryCustomerSalesSummary2006_C1.SumOfEXT_PRICE, (Select Count(*) from _
qryCustomerSalesSummary2006_C1 Where [SumOfExt_Price] < _
[qryCustomerSalesSummary2006_C1].[sumOfExt_Price] AS SalesRank _
FROM qryCustomerSalesSummary2006_C1;

 

[Guest]

I think you should add something like SalesCleckID or you will not know what
the rank means.
SELECT T.SalesCleckID, T.SumOfEXT_PRICE, (Select Count(*) from
qryCustomerSalesSummary2006_C1 As T1 Where T.[SumOfExt_Price] <=
[T1].[sumOfExt_Price] AS SalesRank
FROM qryCustomerSalesSummary2006_C1 AS T
ORDER BY T.SumOfEXT_PRICE DESC;

Or this according the way you want the rank - High to Low or Low to High.
SELECT T.SalesCleckID, T.SumOfEXT_PRICE, (Select Count(*) from
qryCustomerSalesSummary2006_C1 As T1 Where T.[SumOfExt_Price] >=
[T1].[sumOfExt_Price] AS SalesRank
FROM qryCustomerSalesSummary2006_C1 AS T
ORDER BY T.SumOfEXT_PRICE;