Link to home
Create AccountLog in
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
Avatar of sybe
sybe

? What exactly do you mean?

Do you want to insert a value in an autonumber field?
Avatar of 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?
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.
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account