Autonumber

[Frank]

I am using the Autonumber to apply a numberic number to
each case, the problem hits when each case needs the
letters AO placed in front of the number. Our case
numbers start at one each year and run like this:

AO1
AO2
AO3
etc.

How do I get Access Autonumber to add the AO in front of
the Autonumbers?

Thank you for any assistance you can give in this matter.

Frank

 

[Ken Snell [MVP]]

You can't. Autonumber value can be a number only. Use a separate field for
the AO and then concatenate with the autonumber value when displaying the
info on a form or report via a query.

Note that autonumber should not be used for meaningful, sequential
numbers...autonumbers develop gaps (for a variety of reasons) and can become
random or even negative numbers. If you want a meaningful sequence, set up a
macro or VBA programming that gets the next number in a sequence for you.

 

[onedaywhen]

How do I get Access Autonumber to add the AO in front of
the Autonumbers?

See:

http://support.microsoft.com/default.aspx?scid=kb;en-us;240317

Extract: "The Microsoft Jet database engine provides a Counter
(AutoIncrement) field. Starting with Jet 4.0, you can specify a
starting value and an increment value. This solves most of the need for
using a custom counter that users of earlier versions of Jet had.
However, if your counter is a text value or does not increase in a
fixed amount, the steps outlined in this article may benefit your
application."

Jamie.

--

 

[Guest]

The MS Support document was helpful but a little over my head. Is there a
simpler answer given Jet 4.0 is being used and there are no concurrent users?

 

[Joel den Braber]

The MS Support document was helpful but a little over my head. Is there a
simpler answer given Jet 4.0 is being used and there are no concurrent users?