Assign Rank in Query

[blu370n3]

I ran a query that has the following informatiion:

Name, Total Amount, Fixed Amount, ARM Amount

I will need to have 3 different sort, by the Total Amount, Fix Amount, and ARM Amount. I need to add a new column to assign rank based on the value of each sort. For example, on the sort by Total Amount, I need to have rank 1 to n.

Can someone help? thank you.

 

[CT Witter]

Check out MS KB article: 208946 - How to Rank Records Within a Query http://support.microsoft.com/default.aspx?scid=kb;en-us;208946&Product=acc2000

CT

 

[blu370n3]

thanks CT. I am testing it now. will update. much thanks.