In a query, how do I get a column to reflect the row numbers?

G

Guest

When the query is run, I need a column to reflect a sequential numbering of
the rows of the resulting query. For example, if the query results in six
records, there should be a column that sequentially numbers the rows 1 - 6.
 

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

Query to display highest totals 1
how to assign a sequential row numbers for each row in a query in 2
how to create item numbers column in a Query Options 8
How to display multiple IIf results in one column 1
query return only one row with averages 4
Total Row to Sum a Column 1
Query row number 12
Delete a formula but leave the data. 2

Top