Using Autonumber

[AFuturePrez]

I need to create a unique autonumber in a specific format. The
autonumber needs to be the year-log number. For example 07-0001,
07-0001. I am not sure how to do this. Please help.

Sincerely,

Judd

 

[Tom Wickerath]

Hi Judd,

Try this sample database, available on Roger's Access Library:

http://www.rogersaccesslibrary.com/download3.asp?SampleName=AutonumberProblem.mdb


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________