Select Row num with SQL

[Grey]

What is function in Access for showing the row num in SQL?
e.g. Select XXX, field1, field2 from table1

XXX field1 field2
1 data1 data2
2 data3 data4
3 data5 data5

 

[Cheryl Fischer]

To get a "row number/record number" in your query, have a look here:

http://www.lebans.com/rownumber.htm