Can anyone help, very imporant

[abz_y2k]

Hi
i just created a database with people record and a second database which only contains the people record ref number and a waiting list number (which shows how far they r on the q.

What i need to do is, i want the que field to generate numbers automatically from 1-onwards (but dont want to use auto number).. but when i remove like the first person on the que. I want the number to automatically change the second person on que to first etc etc. So as i blank the field of the people in the front of the que i want it to change the status of everyone accordingly

- I dont want to delete any of the records either, i just wanna blank the field once the person on the front of the que has been dealt with .

am using ms 97

is there any way of doing this, i would really appreciate it.. many thanks

 

[neileg]

A number of things:

1) Don't post the same question in different forums, it winds people up.
2) Use a more informative title - 'urgent' will put some people off even opening your post.
3) You are creating a problem because your thinking is wrong. Numbering records dynamically like you ask for is not simple because tables do not have an embedded order. You need to impose an order using a field ( a date or a sequential ID number). Once you've done that, the order gives you your queue and the number is simply cosmetic. Numbering such as you suggest is easy in a report by using the running sum function in the report. Doing it in a query or a table is pretty complex.