Can SQL give sequential numbers to its output lines?

[VickyWass]

Using SQL in Access 2, I want my query to output a field saying '1' against the first line of the resultset, '2' against the next line, etc. Is this something autoincrement does, and if so, how do you write it into the query? I can't work it out from the help files.

 

[petermeachem]

I think the only way to get this to work is to run two queries. The first one to create a table with an autoincrement in and the second to fill all fields bar the autoincrement from your whatever (Use an append query). I assume you are creating a table? Peter Meachem
peter@accuflight.com

 

[JerryDennison]

My question would be why? Typically queries are not used for display purposes but as recordsources for forms or reports(or other queries). You can easly assign row numbers in a report using the running sum property of an unbound control whose controlsource is set to =1.