i want to add auto number field in a query and not in a table
Microsoft AccessSQL
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.
Do you want to insert a value in an autonumber field?