K
Kirt84
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!
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!