Hello,
Does anyone know how to create an autonumber field with SQL for Access 2000 ?
Currently the following does not work
create table ch1(
student autonumber primary key,
question text);
however the following does work:
create table ch1(
student autonumber primary key,
question text);
Obviously the autonumber is the problem, but i need incrementation
Another way of working this out would be to dump a table already created in visual mode into SQL and then checking out the SQL that the program created.
Many thanks !
Does anyone know how to create an autonumber field with SQL for Access 2000 ?
Currently the following does not work
create table ch1(
student autonumber primary key,
question text);
however the following does work:
create table ch1(
student autonumber primary key,
question text);
Obviously the autonumber is the problem, but i need incrementation
Another way of working this out would be to dump a table already created in visual mode into SQL and then checking out the SQL that the program created.
Many thanks !