How to create an ID with the current year on it

[ADFC]

Hello.

How can I create a table with an ID Primary Key with the current year on it?

The format I was looking for could be something like:
14-000

That way when creating a new record the ID field should automatically populate itself with the following:
14-001
14-002
14-003
etc...

And in 2015 it should automatically populate itself with the following:
15-001
15-002
15-003
etc...



Thanks

[trevor40]

Bad idea, if it can be done like that at all. what you need to do is add another pk based on the main pk and date

eg tbl2_pk = tbl1_pk & format(date(),"yy") add the current year to the pk of the table and adds a new pk field.
never needed to do that, so you will need extra advice on how to add this

[ItsMe]

I would try to fight the business rules and concatenate the year to an autonumber field.

I doubt it would be impossible to start a new series each calendar year. I can imagine a couple of solutions. It would be a little bit of code and a pain to develop the app at future dates because you have to consider said series convention.

I suggest concatenate or use the Format property of an Autonumber field at the table level.

>format(date(),"yy")

as a format should display the year and not disrupt the underlying value of the field.

[June7]

I do this. Review: https://www.accessforums.net/forms/n...lly-41161.html