Numbering items in a query (2000)

Topic

New Reply

Is there any way to get a query to assign numbers to the items it finds? Specifically, if the query comes up with five names, I want them numbered 1-5. If the next time it runs it comes up with seventeen names, I want them numbered 1-17. The numbers do not need to be stored anywhere for later use – they can go away when the query closes. I thought I might be able to do this somehow with a counting query, but at least so far I haven’t figured it out that way or any other way.

thanks,
-cynthia

Reply | Quote

Replies

Here a sample database to number a query. It has been posted in a previous post but I don’t find it again.

Reply | Quote