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?


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!!