Autonumber

  • Thread starter Thread starter Guest
  • Start date Start date
It's hard to answer your question without knowing the table structure that
the query is base on.
Incase there is a field that you can sort by, and that field doesn't repeat
itself (apear only once in the query) you can use something like

SELECT (SELECT Count(*) FROM TableName As C where C.FieldName
<=TableName.FieldName ) AS RecordNum, TableName .*
FROM TableName
ORDER BY TableName.FieldName

Note:
FieldName = Unique value within the query
 
Thanks for that. The problem I have is that the query I'm trying to put the
Autonumber into works off another query, which works off another query etc
etc. I know that if it's working off a table I can do it.
 
Back
Top