Row number in a query as in Excel

G

Guest

Dear all
I need a equation (or method) to introduce in aqyery the current row number
in such a way ,the qyery generstes consequtive numbers.
Iknow it is possible in report(field=1 and runnig sum) but i need it in
query not report.
In excel its simple , just =row() in Oracle it is alled "rownum" but I can't
find a way in access ALthought I believe it is possible because the record
selector in the query display the rownumer.

any ideas? thanks for all
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Row number of records as they are fetched 1
Find current row number and select row 2
Excel 2007 List of Materials converted into a report by building 3
Combining Query result rows 5
Numbering Items in a Report 1
syntax in exporting data to excel 1
Running Sum in a Query 1
Help with Query 1

Top