By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,448 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Sequence Numbers

P: 2
How do I create a unique id (sequence number) on an existing table via a query.
Sep 6 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
If the unique Id is an autonumber it will be created automatically. If not use something like the following:

Max([ID]) + 1
How do I create a unique id (sequence number) on an existing table via a query.
Sep 7 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.