Counter field in query

[JKDeveloper0718]

I need a counter field created like a calculated field in an access query such that it will just put a unique value starting at 1 til the query ends. What Im trying to accomplish is I need a automatically generated number per record to insert into an SQL table to give it a unique identity without the field in SQL server being a identity. Ive tried some recommendations on the web nothing has worked right theres always a twist. Any suggestions.

 

[lespaul]

see FAQ701-896 and FAQ701-1155

also to have a search "ranking in Access Query"

see one from MS

http://support.microsoft.com/kb/208946

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins