superblades
New member
- Local time
- Today, 22:25
- Joined
- Sep 20, 2006
- Messages
- 9
Hi all,
Ive been round the houses trying to solve this issue including going through several tutorials but i cant seem to get what i require to work properly.
I'll explain...
I have a projects table with a list of projects and a priority assigned to them. What i want to do is create a query that will display the projects in rank order.
There is an ID column and a Priority Column inside the table.
However when there is more than one project with the same rank it seems to skew them to the lower rank e.g.
ID Project Description Priority Rank
1 Project1 80 1
4 Project4 70 3
7 Project7 70 3
2 Project2 40 4
How can i do it so that the ranking is like the below?
ID Project Description Priority Rank
1 Project1 80 1
4 Project4 70 2
7 Project7 70 2
2 Project2 40 3
Any help is much appreciated.
Regards
Brendan
Ive been round the houses trying to solve this issue including going through several tutorials but i cant seem to get what i require to work properly.
I'll explain...
I have a projects table with a list of projects and a priority assigned to them. What i want to do is create a query that will display the projects in rank order.
There is an ID column and a Priority Column inside the table.
However when there is more than one project with the same rank it seems to skew them to the lower rank e.g.
ID Project Description Priority Rank
1 Project1 80 1
4 Project4 70 3
7 Project7 70 3
2 Project2 40 4
How can i do it so that the ranking is like the below?
ID Project Description Priority Rank
1 Project1 80 1
4 Project4 70 2
7 Project7 70 2
2 Project2 40 3
Any help is much appreciated.
Regards
Brendan