Program AutoID field

[statsman]

I'm, pretty sure the answer to this is a resounding NO, but I thought I'd try it anyway.
I have an AutoID field that records the record number which I then use as a "CaseNo" in the database to track the progress through the system.
Is it possible to program this AutoId to include the year? That is CaseNo 1 would become CaseNo 2005/1.
It would also help to start at 1 again for the first case entered in 2006.
Thanks for any assistance.

 

[Ron_dK]

As far as I know you can't program the Auto ID to include the year or any other additions.
I would suggest making a query which includes something like this :

Case: Date() & "-" & [AutoID]

This would return :

Case
2/9/2006-1
2/9/2006-2
etc.

Hope that helps.

 

[RuralGuy]

I would strongly recommend *not* using an AutoNumber for your Case Numbers. It should *only* be used as a unique primary key for a table and *never* be seen by the user. I guess you missed Commandment 7 of The Ten Commandments of Access Search this forum and you will find pleanty of alternatives that will suit your needs better than an AutoNumber.

 

[JoeCruse]

statsman,

do a search on this site for custom autonumber. There hav been several good threads on this subject. It can be done, but it has to be done with code and not with an autonumber field, unless you do what rak suggests.