Make Table: Create AutoNumber field

[jempie]

Hi All,

I am trying to create a make-table query, with a new AutoNumber field.

I know that if you are creating a new Text field you type FieldName: "" in Field and for a Number field you would type FieldName: [], but what do you type for an AutoNumber field?

 

[Dennisk]

You need to create your table ignoring the autonumber fields for the time being.

When you have created the table enter table design and add your autonumber field. Open the table and the autonumbers will have been generated for you.

you can append to this table ignoring the autonumber field which will be handled internally by the Jet Engine.

 

[Len Boorman]

If you are creating the table usiong a Make Table query and firing this query automatically from some other action you can add the autonumber field again by query,

CVheck help on Alter Table statement. Note that Autonumber type is declared as COUNTER within sql statement

L