Thread: unique record numbers
View Single Post
  #2  
Old March 6th, 2010, 04:18 AM posted to microsoft.public.access.tablesdbdesign
Tom van Stiphout[_2_]
external usenet poster
  
Posts: 1,653
Default unique record numbers
On Fri, 5 Mar 2010 19:19:44 -0800, Rev David Bissas Rev David
wrote:

The "DMax + 1" technique should work for you. Google or Bing for it.

-Tom.
Microsoft Access MVP


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.