Inserting with autonumber field

[gry086]

I want to insert some rows into a table called 'payments'
Every payment has an ID (auto-number)

I am more comfortable doing this procedure using the SQL view of Access 2007.

what is the syntax to insert the next logical value into an auto-number field?
In MySQL I would write 'default' for that value.
INSERT INTO `payments` VALUES ('default', '1000', '2');

This does not work in access. Access just prompts me for the value of 'default'

 

[boblarson]

Leave off the autonumber field and just insert the other fields. The autonumber will take care of itself.

 

[gry086]

Thanks for the prompt reply, Bob, it worked well.