Can I add an Autonumber field in a MakeTable query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Each time I make the table, the information changes, but I want the fields
numbered 1,2,3,4... always starting with one.
 
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.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Table Query and Autonumber Fields 6
Maketable query with Autonumber column 1
Queries losing fieldnames when importing from external mdb 2
Append query - Append to table with Autonumber field 2
running total of records in query 1
Create Date Field from Text 2
Problem with Make Table Query - Resultant Table not allowed to have more than one AutoNumber field. 5
Defining Text field sizes in destination Make-Table Query 3

Back
Top