How can I begin an auto number field with PC+the next number?

[Guest]

I'm using an auto number field to number the entrys and we will use refer to
the numbers in outside reports and such, is there a way to add the letters PC
before the auto number?

 

[Joseph Meehan]

I'm using an auto number field to number the entrys and we will use
refer to the numbers in outside reports and such, is there a way to
add the letters PC before the auto number?

First and foremost: 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.

There are other ways of providing the numbers you want depending on the
particual application.

Second, I would not add and save new result with the letters.

If you fell you still want to use autonumbers, then I suggest you use a
formula to create the letter-number combination whenever and where ever you
may want it.

 

[Guest]

We need the "PC" as a way to distinquish from other engineering changes, we
use a set of letters with numbers to tell us which change it is refering to,
i.e. AXXX, XXXX, MXXXX, CMSXXX, each of these refer to a different product
line and the numbers only refer to our first product manufactured.

I guess I've been lucky with Access auto numbering because I've never had it
not number correctly and by that I've been able to spot immediately when
someone has deleted an entry because while I create the database others also
have the ability to make changes.

I've done a bit of programming with in Access and if that is what I have to
do, please tell me how to do that.

Thanks for the help.

 

[Guest]

You can format it to "PC"000 in the format property

 

[Guest]

Thank you, I knew it could be done, but just couldn't find the answer.
Thanks very much

Leslie

 

[Joseph Meehan]

We need the "PC" as a way to distinquish from other engineering
changes, we use a set of letters with numbers to tell us which change
it is refering to, i.e. AXXX, XXXX, MXXXX, CMSXXX, each of these
refer to a different product line and the numbers only refer to our
first product manufactured.

I guess I've been lucky with Access auto numbering because I've never
had it not number correctly and by that I've been able to spot
immediately when someone has deleted an entry because while I create
the database others also have the ability to make changes.

I've done a bit of programming with in Access and if that is what I
have to do, please tell me how to do that.

If I have this figured out. You may want various prefix letters to
different records. I suggest that you may a text field for the prefix part
and leave the autonumber alone if you are happy with it. You can change it
later when it becomes a problem, which it likely well.

Just combine the two fields when you need them so it will look like a
single field.