counting like autonumber

[qaccess]

how can i create a row in a query that acts the same as autonumber. I have a column named goals that only contains the number 1.

For example the query contains 3 rows. What I want is that another column counts from 1 to 3.

autonumber goals count
1 1 1
2 1 2
3 1 3

ThanXs

 

[qaccess]

Thanxs

Thanks for your answer. But it is not what I want. Even it is not possible. I create a table with soccer results. like

personA goal minute
john 1 30
bob 1 35


i like to create a query where number is not autonumber but a formula which start with 1 and then counting 2,3,4,5 etc.

personA goal minute number
john 1 30 1
bob 1 35 2

 

[meboz]

Could you reference the Microsoft Excel Object Library and use the RANK() function within a query?

I can see that your query works Pat, just wondering if RANK would work also

 

[qaccess]

Thanks

Dear Pat,

Is it possible that you send me that piece of access with code you wrote in a mdb file. I am not so experiend with access. Thank you.

 

[qaccess]

Thanks Pat

Pat, thanks for the information