G Guest Aug 3, 2005 #1 Each time I make the table, the information changes, but I want the fields numbered 1,2,3,4... always starting with one.
Each time I make the table, the information changes, but I want the fields numbered 1,2,3,4... always starting with one.
G Guest Aug 3, 2005 #2 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.
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 Aug 4, 2005 #3 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)
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)
