Ranking records

[Schuitkds]

Hello,
I have a query to report on sales results.
what i would like to do in the query is to rank sales items by total sales
so ex
clothing $500
Jewlery $1000


i would like Jewlery to be ranked as 1 and
clothing as 2
and etc
seems simple but
everything i have tried does not work.

 

[Klatuu]

Create a Totals query.
Make item Group By
Make Total Sales Sum
Order by Total Sales Descending

 

[Schuitkds]

thanks
how would i pop a field in the query to reflect the ranking?
field would actually have values of 1 2 3 etc in it

 

[Marshall Barton]

I have a query to report on sales results.
what i would like to do in the query is to rank sales items by total sales
so ex
clothing $500
Jewlery $1000


i would like Jewlery to be ranked as 1 and
clothing as 2
and etc
seems simple but
everything i have tried does not work.

Add a calculated field to the query. The general idea is:

Rank: (SELECT Count(*)
FROM table As X
WHERE X.totalsales <= table.totalsales)

It's may be more complicated than that if your query has
grouping and/or criteria.

If you have problems getting it work in your situation,
please post a Copy/Paste of your query's SQL statement.

 

[Klatuu]

I know it can be done, but I don't know how.

thanks
how would i pop a field in the query to reflect the ranking?
field would actually have values of 1 2 3 etc in it