Ranking in Access 2010

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
 
I do not have 2010 but a copy of your SQL might have helped, however at a guess do you have >= in your as rank condition in the sub query , if so remove the =

Brian
 

Users who are viewing this thread

Back
Top Bottom