I have a field as primary and unique. I try to INSERT INTO [table1] VALUES (null,...). It will not automatically jump to the next available number. Is there a Auto-Increment feature in Access and how do I use it?
Novice
Windows Vista 
Access 2010 32bit
I have a field as primary and unique. I try to INSERT INTO [table1] VALUES (null,...). It will not automatically jump to the next available number. Is there a Auto-Increment feature in Access and how do I use it?
Who is John Galt?
Windows XP Access 2007
Well, there's an Autonumber data type. See if that does what you want (you wouldn't include the field in your SQL).
Auto Increment Textbox
Auto increment a number and be able to modify value after increment has taken place.
Posting Permissions
Reply With Quote