Count Each and Assign Number



I have a query of one hundred items numbered 1 to 100. I want to select some
of them with a YES/NO field. In a query, I select those records checked
"YES". They are kept in order based on their number.

Then, I want to assign a new number 1,2,3 etc. for as many records as the
query pulls up. I just want a running count.

Could anyone tell me how to do this?

Duane Hookom

You can do this quite easily in a report. If you really think you need this
in a query, search this news group for "ranking".

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