Sequence Numbers

jferrara

New Member

Join Date: Sep 2006

Posts: 2
#1

Sequence Numbers

Sep 6 '06, 11:39 PM

How do I create a unique id (sequence number) on an existing table via a query.
Tags: None
MMcCarthy

Recognized Expert MVP

Join Date: Aug 2006

Posts: 14387
#2

Sep 7 '06, 12:27 AM

If the unique Id is an autonumber it will be created automatically. If not use something like the following:

Max([ID]) + 1

Originally posted by jferrara

How do I create a unique id (sequence number) on an existing table via a query.
Comment

Comment