unique record numbers
in [Tables]
|
From: accessnewbie79915 on 11 Mar 2010 18:10 I am new to access myself, but I do know enough to say that if you adopt the autonumber setup it would work better for you. However, do not skip numbers when building your database. The reason for this is that when it comes time to query your data into reports and forms, if you skip numbers it could cause problems pulling in the data that you want. "Rev David Bissas" wrote: > I am trying to create a unique PIN for members in a table (not the primary > key) that will be 4 digits long, and would like each new entry to be > incremental. I am very new, and would appreciate a detailed instruction > (though I can get around access fair enough). Any help would be appreciated.
From: Jeff Boyce on 14 Mar 2010 15:15
Depending on your definition of "autonumber"... If you mean what Access provides, we can almost guarantee there will be "skipped" numbers. If you mean a custom "autonumber" (lower case) function, it could ensure that numbers are guaranteed sequential ... BUT! if someone were to delete a record, there would still be a missing/skipped number! Good luck -- Regards Jeff Boyce Microsoft Access MVP Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "accessnewbie79915" <accessnewbie79915(a)discussions.microsoft.com> wrote in message news:51ECFB90-05B5-4FD8-8DEF-0DF5B90F6A85(a)microsoft.com... >I am new to access myself, but I do know enough to say that if you adopt >the > autonumber setup it would work better for you. However, do not skip > numbers > when building your database. The reason for this is that when it comes > time > to query your data into reports and forms, if you skip numbers it could > cause > problems pulling in the data that you want. > > "Rev David Bissas" wrote: > >> I am trying to create a unique PIN for members in a table (not the >> primary >> key) that will be 4 digits long, and would like each new entry to be >> incremental. I am very new, and would appreciate a detailed instruction >> (though I can get around access fair enough). Any help would be >> appreciated. |