Query To Count Levels (1 Viewer)

[Dreamweaver]

I do remember getting an answer to this a few years but can't find the post as at the time didn't need to use as had a code solution but am starting something new an would like to use the query.
I have a totals query that returns
Total
5
4
3
3
2
2
2
1
1
1
This would normally give an output like
Position, Total
1, 5
2, 4
3, 3
4, 3
5, 2
6, 2
7, 2
8, 1
9, 1
10, 1
But I need it to output like
1, 5
2, 4
3, 3
3, 3
4, 2
4, 2
4, 2
5, 1
5, 1

thanks

 

[isladogs]

Use a rank order query. See Rank Order Queries - Mendip Data Systems

 

[Dreamweaver]

Thanks.