query to assign an incremental # based on order sorted 1

[basement131]

For MS Access
is there a function that exists or can someone build me one, so that i can assign an incremental number to a record based on the order that the records are sorted. such that the 1st record would be 1, 2nd=2, 3rd=3, etc.


Your help & assistance today will be passed on to others tomorrow.

 

[PHV]

Do a keyword search in this forum for rank or ranking

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[basement131]

Thanks PHV for informing me about Rank or Ranking
i did not know that existed. I used the help you provided on the following. thread701-1144664

it took a little modifying & T&E but i got it to work

Thanks.

sometimes providing the right direction is just as good as driving them there.


Your help & assistance today will be passed on to others tomorrow.