OK I have done something stupid, but i wanted to learn how to interface a database by using SQL, problem being that the database I'm using is MS access, I know this isn't the best db to do it with but hey, you got to be young and stupid at some point.

I have a problem where I'm getting an error saying missing field, which it is indeed missing, but i need to figure out a way to tell the db to create an auto number for that record automatically.

Is there a way to do this or do I have to search through the db to find the largest id and add 1 to it.

Code:
For example can you just write;  insert into table(row,row,row) values(number.autonumber(),value,value);
Thanks