can I start the autonumber field from BP0001 and increment from there?
Reply from Richard Rost:
Nope. Your AutoNumber will start at 1 and Access will increment it for you automatically. You have NO control over it... and you shouldn't use it for anything. It's an internal number that Access uses for tracking relationships between tables (which we'll learn in Access 201). You can create your own custom counter fields, but that will require a little programming... and we cover that in the 300 series.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 3.