Adding Rank Value to list

  • Thread starter Thread starter Haji
  • Start date Start date
H

Haji

I have a transaction table which has CustomerName, Item,
Qty, and Amount. I wrote a query that summed customers
by amount. What I want to add though is a rank. I want
to add a calcuated field in my query that will figure out
who the top ranked customer is and place a one in that
field followed by the second highest revenue customer and
place a 2 in that field. Can anyone help?

Thanks,

Haji
 
Haji said:
I have a transaction table which has CustomerName, Item,
Qty, and Amount. I wrote a query that summed customers
by amount. What I want to add though is a rank. I want
to add a calcuated field in my query that will figure out
who the top ranked customer is and place a one in that
field followed by the second highest revenue customer and
place a 2 in that field. Can anyone help?
Click to expand...

Read the info on this site to find out how to do that:

http://support.microsoft.com/defaul...port/kb/articles/Q208/9/46.asp&NoWebContent=1
 
Back
Top