Number rows in a sql query

[compwizard]

I know that this is a little bit off topic, but is there a way in ms. Access or sql to number the rows of a query?

ie.

numrows field 1
------- -------
1 afffdfds
2 kjljkl
3 hhfdfd

I can do it in a report, but i can;t get it to work with a query. Any help would be greatly appreciated!!

[jofa]

Something like this:

select
  (select count(t1.id) from table as t1 where t1.id <= t2.id) as numrows, 
  t2.id as id, 
  t2.field1 as field1
from
  table as t2
order by 
  t2.id

http://support.microsoft.com/directo...EN-US;Q186133&