Automatic unique number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I require a function where Access will generate an Automatic identification
number. Firstly I would like the date to be displayed in number form. Finally
after the date I would like a / or . followed by two numbers

For example if it were today’s date (3rd August 2006):
*Any 1 of the 4 combinations would be fine

03082006.00
03082006/00
03/08/2006.00
03/08/2006/00

Therefore, the date would stay the same and the two last would change every
time a new record is entered. E.g. 01, 02, 03, 04, 05 etc

Also the numbers have to be unique, therefore what ever the date is this
should always change everyday. I am still a novice in Access so if
someone can give me a step by step guide it would be great!
 
Kirt84 said:
I require a function where Access will generate an Automatic
identification number. Firstly I would like the date to be displayed
in number form. Finally after the date I would like a / or . followed
by two numbers

For example if it were today's date (3rd August 2006):
*Any 1 of the 4 combinations would be fine

03082006.00
03082006/00
03/08/2006.00
03/08/2006/00

Therefore, the date would stay the same and the two last would change
every time a new record is entered. E.g. 01, 02, 03, 04, 05 etc

Also the numbers have to be unique, therefore what ever the date is
this should always change everyday. I am still a novice in Access so
if
someone can give me a step by step guide it would be great!
Click to expand...


I am almost certain someone asked this same question in the last few
days with the addition of a three letter code in front, but I could not find
it.

I have not need to use a resetting incremental number so about the only
suggestion I can offer is that you will be using the DMAX function to find
the last number and then increment it. I don't think the whole thing
(including the rest with the change of date) should be too difficult.

I will make one suggestion. Think long and hard about those two digits.
What happens when you have 105 events on one day. Sure you don't think it
could ever be that many, but believe me, it will happen once you get
everything set and you will end up changing forms reports tables VBA code
etc. Make accommodation for it now and not be sorry later.
 
Back
Top