Make Table Query

[bird44ca]

Is there any way to add an Autonumber column with a make-table query?

 

[Alexandre]

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]

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.