Avatar of aroh9barve
aroh9barve
 asked on

adding auto number in MS Access Query

i want to add auto number field in a query and not in a table
Microsoft AccessSQL

Avatar of undefined
Last Comment
Scott McDaniel (EE MVE )

8/22/2022 - Mon
sybe

? What exactly do you mean?

Do you want to insert a value in an autonumber field?
aroh9barve

ASKER
i know we can add a auto number field in a table. But, if i have a table on which i have created a query to sort the list using few criterias, and then i want to give it a 6 digit auto number, then how do i do it?
sybe

Where would you get that autonumber from? Or do you mean something like a rownumber?

A "6-digit auto number"? You mean like 000001, 000002 etc? Because that would be equal to 1, 2 etc. The leading zero's have no meaning in a number. But you could have them in a string.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER CERTIFIED SOLUTION
Scott McDaniel (EE MVE )

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.