I found this from different fourm by searching google. This is exactly what I need to do and the answer was given; however, I can't figure it out. Can someone please post a step by step instruction on how to complete the following.

Thank you!


Question

I have a datbase full of projects that must be ranked in priority order. This was simple enough but when I add a project I will likely need to change the priority rank of all the "lesser" projects. With over 500 projects adding a new project with a rank of 50 means changing all the ranks 50 and above. I want to be able to add a project and when I determine its rank I insert the rank number and every rank equal to the project just added is the indexed by 1 digit. No two project can be ranks the same, one is always more important than another.


Answer

Create an update query that sets the priority field to:

[Priority] + 1

then set the criteria to

>= new number

Where new number is the rank of the new number.

This will increment by one each priority.

Hope this helps,
Scott<>

Yes I found it, the question is here: (http://en.allexperts.com/q/Using-MS-Access-1440/priority-ranking-adjustments.htm#b)

Looks like an exam question or something. So have we caught an examiner out now plagiarizing the Internet?

I hope your not serious, ha! Well, since they call the "Access Man", can you help me with a priority field as explained in my first post? I'm a bit confused here.

Thanks

Well I suppose I could, but you're have to help me out a bit first.

Why are you so keen on having the answer to this question?

Intrigued from Newbury Berkshire

Ok, here’s the deal. I'm building a project based database for my work. Until now, everything was being tracked with an excel sheet; which in my opinion is a complete disaster. So, I took it upon myself to create a database using Access 2007. This is my first time using access or any database manager. I have the basis of the database set but need to make some refinements. One very important thing I need is project prioritization; without that, all I have is a fancy looking excel sheet. Since I'm dealing with over 75 projects at any given time, I need to set each project with its own independent priority status (not grouped by High, Medium or Low).

That being said, I ran a Google search using "access priority field"; the first result of that search links to the forum with the Q&A that I copied and posted here. What’s sated in the forum is exactly what I would like to accomplish; however, because I am new to access, I need a better explanation than what was given (step by step instruction would be great!).

I stated in my original post that the Q&A was from a different forum. Maybe I should have sited my source, so here goes.

Sources:

AllExperts
Expert: Scottgem
Date: 8/24/2004
Subject: priority ranking adjustments
http://en.allexperts.com/q/Using-MS-Access-1440/priority-ranking-adjustments.htm


I would very much appreciate your help!

Thank you

Please could you post an access 2003 or earlier version; including some sample data and the priority field.