Creating an unique ordered number field with auto shifting values.

[TaSMaNiaC]

Hi,

I'm creating a database using existing data from an excel file full of contact details. What I need to add is a queue type system where each contact in the database has a "Place in Queue" number which is unique obviously. Lets say Alan is number 1, Bob is 2 and Chris is 3. They have these corresponding numbers in the queue field for their entries. Now what I need to have, through use of a form, is a way of changing Chris from number 3 in the queue to number 1 and thus have Alan automatically shift down to number 2 and Bob to 3. I hope I've described this properly and it makes sense. I've been tinkering around trying to figure this out but I have no clue how to actually achieve this. Could anyone be as helpful to point me in the right direction?

Thanks in advance!

Tasman

[Rainlover]

You may get away with an update query which adds One to each record within that set of records. You do have a start and finish value.

If that doesn't work then you are going to need some VBA code, to loop through the affected records.

[orange]

You say you need a form and some method to change the various positions in the queue. Do you have an algorithm for these queue position changes? I think that's where you have to start.

Do you need to -
-add a new person in the queue, and requeue
-remove any one or many from the queue and requeue
-randomly modify the queue
-???

What exactly are you trying to do -- in plain English?

If you can't define/describe it, you'll have a hard time doing it.