B
Beverly76
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?
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?