setting a field as an autonumber.

ia04

New member
Local time
Yesterday, 18:01
Joined
Aug 23, 2006
Messages
7
I am creating a table with a field named Payment ID. I want the table to increment the number of this field automatically when the user is trying to enter a new record, i.e. set the field as an autonumber.

I know that this is very basic, my MS Access skills is really limited.

Cheers.
 
In table design view, selct autonumber as the field type.
 
Just remember that an autonumber just assures that you have a unique value. It isn't something to use if you want to keep a number sequence intact. You will want to use a dlookup and have a custom process for incrementing, if you want it to keep a number sequence intact. Search for posts on autonumber and dlookup for more info.
 

Users who are viewing this thread

Back
Top Bottom