add counter to query

[hortense76]

Hello. I'm trying to add a counter to the fields of a query. Purpose is to have a second query choose from this a selected record and next x records, which, of course have been already sorted by first query itself.
I thought the simplest way was with a simple automatic-generated counter, but perhaps I'm making it complicated and there's a simpler way. Any idea?
thanks

 

[RuralGuy]

http://www.lebans.com/rownumber.htm

 

[hortense76]

Once again, THANKS RG !
It worked. Strange there's no build-in feature like this: an automatic counter field... anyway: fine everything ends fine! Thanks again

 

[RuralGuy]

You're welcome. We're very lucky to have Stephan Lebans around.