How do I create an autonumber colmn in a query?
A Allen Browne Feb 26, 2010 #2 See the first example here: http://allenbrowne.com/func-DDL.html#CreateTableDDL
A Allen Browne Feb 26, 2010 #3 Re-reading your question, I'm not clear if you are talking about executing a DDL query statement to create an AutoNumber in a table, or whether you are talking about dynamically numbering the records directly within the query. If the latter, see the options suggested here: http://allenbrowne.com/ranking.html#query
Re-reading your question, I'm not clear if you are talking about executing a DDL query statement to create an AutoNumber in a table, or whether you are talking about dynamically numbering the records directly within the query. If the latter, see the options suggested here: http://allenbrowne.com/ranking.html#query
