S
Secret Squirrel
Right now I'm using an AutoNumber as my return material authorization #'s.
Can I add a prefix to this number or is that not possible? I already have
about 300 records in my database so I would want to go back and have it add
this prefix to the existing records. There are 2 prefixes that I need to add.
First I need the letters "BC" and then the 2 digit year and then my
autonumber. So it would look something like this "BC0635". Anyone have any
ideas on how I can accomplish this?
Can I add a prefix to this number or is that not possible? I already have
about 300 records in my database so I would want to go back and have it add
this prefix to the existing records. There are 2 prefixes that I need to add.
First I need the letters "BC" and then the 2 digit year and then my
autonumber. So it would look something like this "BC0635". Anyone have any
ideas on how I can accomplish this?