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

L

Leslie

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

Leslie

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

Leslie

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

Leslie
 
Top