Ranking

[charlee63]

How do I do a ranking in Access?

May Query Produces

520215	447036	58	$1.08
520215	447036	1	$10.28
520215	447036	1	$10.64

<caption>qryWest HI Dairy</caption>

<thead>


[TH="bgcolor: #c0c0c0"] Vendor [/TH]

[TH="bgcolor: #c0c0c0"] MaxOfItem [/TH]

[TH="bgcolor: #c0c0c0"] Expr1 [/TH]

[TH="bgcolor: #c0c0c0"] Expr2 [/TH]




</thead>
<tbody>


</tbody>
<tfoot></tfoot>

I need to have a Rank in before them as 1,2,3.

[TABLE="width: 872"]
<colgroup><col style="width: 48pt;" span="2" width="64"> <col style="width: 91pt; mso-width-source: userset; mso-width-alt: 4425;" width="121"> <col style="width: 48pt;" width="64"> <col style="width: 434pt; mso-width-source: userset; mso-width-alt: 21138;" width="578"> <col style="width: 203pt; mso-width-source: userset; mso-width-alt: 9910;" width="271"> <tbody>[TR]
[TD="class: xl65, width: 64, bgcolor: transparent"]Field:[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Rank:??[/TD]
[TD="class: xl65, width: 121, bgcolor: transparent"]Vendor[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Item[/TD]
[TD="class: xl65, width: 578, bgcolor: transparent"]Expr1: [QryWest HI Dairy Sum]!SumOfCases+[QryWest HI Dairy Sum]![SumOfForward Buy][/TD]
[TD="class: xl65, width: 271, bgcolor: transparent"]Expr2: CCur([West Hawaii Dairy]!Amount)[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Table:[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]West Hawaii Dairy[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Total:[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]Group By[/TD]
[TD="class: xl65, bgcolor: transparent"]Max[/TD]
[TD="class: xl65, bgcolor: transparent"]Group By[/TD]
[TD="class: xl65, bgcolor: transparent"]Group By[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Sort:[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]Ascending[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]Ascending[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

See here: https://usefulgyaan.wordpress.com/2013/04/23/ranking-in-ms-access/

 

[apr pillai]

Check this:https://www.msaccesstips.com/2011/09/preparing-rank-list.html