Row numbers in a query

  • Thread starter Thread starter Alberto Uttranadhie
  • Start date Start date
A

Alberto Uttranadhie

Hi, everybody,

I would like to insert a field in my that shows the row number beginning
from 1 to last record in my query's recordset (for example, 1 to 148). Is
there any SQL statement with I could set such field? Or should I write a
method?

Thanks in advance.

Alberto Uttranadhie (Spain)
 
See:
http://www.lebans.com/rownumber.htm
Rownumber.zip is a database containing functions for the automatic row
numbering of Forms, SubForms and Queries.

Updated Oct. 13 by Allen Browne. Includes error handling and cleaned
code.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Back
Top