Auto numbering a select query -

[simon mills]

Can this be done ??

I have a query on a timer that basically looks at a linked table every minute and tells me whose in the database. I want to number the rows in a column so I can reference this to a form that has 7 spaces. The number of 'users' could vary from 0 - 23, although this will soon be limited to 7 (hence the 7 spaces) to aid performance and speed. I am then going to reference the number to the unbound space on the form, iif(isnull()) 'ing the blank cells so it isnt an error.

I thought of an append query, but the sequence will always start at the next number, not from 1 each time - or as far as im aware it will - so I cant reference the cell then.

Can any one help please.

 

[SMatthews]

Check out this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=94510

and/or this link:

http://databasejournal.com/features/mssql/article.php/10894_2244821_2

Let me know if these help.

 

[simon mills]

Thanks for the links. I will take a look through each. Another thought presented would be to change the query to a make table query query and have an auto number on that ...... But if these work better and quicker because its all done in one then great.

Thanx for your time in helping. I will let you know what happened.