numbering results of query on form

[Flynners]

Hi
I have a query that returns total scores in descending order. I present that on a form but i want my form to show the scoring position
eg
1. ABC Company 100
2. DEF Company 90
3. GHI Company 80

How can i number each line on the form WITHOUT writing the results of the query to a temporary table. I want to avoid temporary tables as I want the user to update tick boxes on this form based on scores.

How do I get the form to count the number of rows and assign numbering. Is it something i can assign within the query rather than the form?

thanks in advance!

 

[Flynners]

I worked out the numbering on the form using a previous post from ajetrumpet

rownumber: DCount("orderid","orders","orderid <=" & [tempHOLDER]) & "."
tempHOLDER: orderid

His version using rownumber and tempholder in the query worked with some tweaking. When I inserted these columns into my query it didnt give me the desired results as i had further criteria in my query.
eg say my query showed 6 results, but if i specified status of "pass" only, which would have shown 2 results my row numbers were 3, and 6 rather than 1 and 2.

I used the rownumber and tempholder in a query on my original query and it worked fine.

thanks ajetrumpet!