In an MS Access Maketable query, how to create an Autonumber field?
Posted
by PowerUser
on Stack Overflow
See other posts from Stack Overflow
or by PowerUser
Published on 2010-03-12T15:40:17Z
Indexed on
2010/03/12
15:57 UTC
Read the original article
Hit count: 261
I have a Maketable query in an Access db that could use an Autonumber field. I can't find a built-in function for my purpose. Do i need to write my own? Ideally, I'd just like to create a field in the Access designer as "Autonum: CreateAutoNumber()"
Edit: If it can't be done in the query itself, I can also run a procedure afterward.
© Stack Overflow or respective owner