Make auto number display year and an increasing number (yy-###)

[Guest]

I want an increasing number as a key, but to display the year first and reset
to 0 when a new year starts

 

[Joseph Meehan]

I want an increasing number as a key, but to display the year first
and reset to 0 when a new year starts

I suggest you may not want to use Autonumber for that use. Autonumbers
are designed to provide unique numbers. It in not designed to provide
numbers in order and for a number of reasons may not do so. As a result
using them in any application where the user sees the numbers is likely to
end up with confusion.

How important is it to have consecutive numbers? Do you really need the
date in the key field? You could keep the date in another field and combine
them for display as needed.

 

[Van T. Dinh]

Search these newsgroups / Google Group Search for "Custom Number Sequence"
as this topic comes up regularly.

 

[Guest]

Well basically, that's what I'm trying to do, is to combine them for display,
but I don't know how.

 

[Joseph Meehan]

Well basically, that's what I'm trying to do, is to combine them for
display, but I don't know how.

As in a report? I would think that would work. Have you investigated
metrunec86's suggestion of looking into custom number series?