Can I add an Autonumber field in a MakeTable query?

T

Tracee

Each time I make the table, the information changes, but I want the fields
numbered 1,2,3,4... always starting with one.
 
K

KARL DEWEY

In the design view of the query grid - FIELD row insert 1: [YourDataField]
instead of just selecting the source field. The field name in the table it
will make will have "1" as the field name. Do the same for the rest of the
fields.
 
D

david epsom dot com dot au

Yes. You can add an Autonumber field from another table.

But you will have to have two queries: one maketable query
to make an Empty table, and then an Append query to
put data into the new table.

(david)
 
Top