Count Each and Assign Number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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".
 
Back
Top