Custom Serial Number Format Based Upon Julian Date.

[MKTetzlaff]

Hello:

I need to create a serial number that auto increments based upon the following format:

Last two digits of the year + Julian day of the year + two digit unique incremented number.

1610604 would be 2016 on the 106th day and the 4th unit and the next number would be 1610605.

I do not believe that we will ever exceed 99 units per day.

I have Access 2016 and believed that I could do it in the Format section of a AutoNumber field.

Any help would be greatly appreciated.

- Mike T.

 

[MKTetzlaff]

Thanks Joe.

I will give it a try and let you know.

- Mike T.

 

[MKTetzlaff]

Thanks for the heads up.

It was my first concern; however the serial number is tied to another legacy system and I was told I could not change the format.

So we will probably have to cross that bridge in the future.

Thanks again for the input.

- Mike T.

 

[MKTetzlaff]

Hi Joe:

I just started on this project and your code and directions worked perfectly.

Thank you for your time and patience.

- Mike T.

 

[Joe4]

You are welcome!