Dreamweaver
Well-known member
- Local time
- Today, 01:58
- Joined
- Nov 28, 2005
- Messages
- 2,466
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
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