How do I do a ranking in Access?
May Query Produces
<caption>qryWest HI Dairy</caption>
<thead>
</thead>
<tbody>
</tbody>
<tfoot></tfoot>
I need to have a Rank in before them as 1,2,3.
<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>
</tbody>
May Query Produces
Vendor | MaxOfItem | Expr1 | Expr2 |
---|---|---|---|
520215 | 447036 | 58 | $1.08 |
520215 | 447036 | 1 | $10.28 |
520215 | 447036 | 1 | $10.64 |
<thead>
</thead>
<tbody>
</tbody>
<tfoot></tfoot>
Field: | Rank:?? | Vendor | Item | Expr1: [QryWest HI Dairy Sum]!SumOfCases+[QryWest HI Dairy Sum]![SumOfForward Buy] | Expr2: CCur([West Hawaii Dairy]!Amount) |
Table: | West Hawaii Dairy | ||||
Total: | Group By | Max | Group By | Group By | |
Sort: | Ascending | Ascending |
<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>
</tbody>