Hello, I have made a simple query, and I need to allot AutoNumbers to a field.
What could be the expression for this ?
Thanks and Regards
Hello, I have made a simple query, and I need to allot AutoNumbers to a field.
What could be the expression for this ?
Thanks and Regards
???Please describe your requirement in simple, plain English and provide a before and after sample if possible.
Autonumber is a special datatype for a specific purpose.
Hello,
My english is weak.
I have two fields in my Query, one is text and other is Numeric.
I have applied a Filter on the text one and after applying the filter, I want other field in the query to have AutoNumbers.
Thanks
You may want to google "Access rank query".
http://allenbrowne.com/ranking.html
https://usefulgyaan.wordpress.com/20...-in-ms-access/
Cheers,
Another example for you to try: https://www.msaccesstips.com/2020/01...version-2.html