How do I number each row in a query result?

S

srp822

If there are 10 rows in the select query result, how can I have the query
number each row from 1 to 10?

Thanks in advance.
 
J

Jeff Boyce

What will having "row numbers" allow you to do?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
S

srp822

I want to have the results numbered. It's not really about having row
numbers. Any ideas?
 
J

Jeff Boyce

Use a report to output the results of your query. Add a text control, set
the Running Sum property to Yes. This will appear to "count" the rows.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
O

owp^3

I do that in most cases but I have a circumstance where I need to retain the
resulting "rank" as a data element which will be appended to a table.

What formula can use to number each row in query designer?

Thanks,
owp^3
 
J

Jeff Boyce

Consider re-posting as a new item, rather than adding to this existing
thread.

That way, you'll get more eyes/brains considering your question.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top