Syntax for Inserting a record with an autonumber field
Posted on 2004-09-06
I am trying to insert a record into a table that has four fields and I do not know the syntax for inserting a record with the an autonumbered field.
Table name - Autotest
Field 1 - id, Number data type
FIeld 2 - name, Text data type
Field 3 - id2, Autonumber data type
Field 4 - description, Text data type
The SQL statement I am trying to run is:
INSERT INTO autotest
VALUES (1, 'chon', , 'female');
I've tried ## in the space for the autonumber and several others but I get a data type mismathc when running it.
Please advise on the proper SQL syntax for MS Access.