Autonumber

F

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
 
K

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.
 
W

Wants To Know

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?
 
J

Joel den Braber

Wants To Know said:
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?
Click to expand...
 
Top