Select a rowid from a query 2

[jmstarbuck]

Is there a way to select a row id from a query so that the rows selected in that query are numbered?

Something like "Select ? as rowid, a, b, c from tableF"

1 a b c
2 a b c
3 a b c

 

[lewatkin]

jmstarbuck,

follow this link and download the zip file - there are 2 examples in that little database that may help you. I have to give credit to

http://www.rogersaccesslibrary.com.

He has some really cool samples there.

http://www.rogersaccesslibrary.com/download3.asp?SampleName=NumberedQuery.mdb

Lee

 

[cmmrfrds]

One way is to create a self join on the table.
For example.
SELECT Count(*) AS row, A.order
FROM TestOrder AS A, TestOrder AS B
WHERE (((B.Order)<=A.order))
GROUP BY A.order
ORDER BY A.order;

You could save this as a query, say with the row number and an ID and then join to your table in another query to supply the row number.

 

[jmstarbuck]

Thanks to both of you for your helpful suggestions. I've got it working!