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 then 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

I would have a look at some of Rogers examples, possibly this one in particular: (http://www.rogersaccesslibrary.com/download3.asp?SampleName=NumberedQuery.mdb)