bird44ca
02-25-2002, 05:08 PM
Is there any way to add an Autonumber column with a make-table query?
|
View Full Version : Make Table Query bird44ca 02-25-2002, 05:08 PM Is there any way to add an Autonumber column with a make-table query? Alexandre 02-26-2002, 01:23 AM CREATE TABLE tblCustomers (CustomerId COUNTER, [Last Name] TEXT(50) NOT NULL, [First Name] TEXT(50) NOT NULL, Phone TEXT(10), Email TEXT(50)) Alex SimonC 02-26-2002, 07:14 AM If the MakeTable query includes an AutoNumber field in its output, then that field in the new table will also be an AutoNumber field. However, the values the MakeTable query inserts in the AutoNumber field in the new table will be based on the values in the query's source table, they won't be generated by the new table's AutoNumber field. As a result, they may contain duplicates. Simon. |