Q
Question Mark
When adding a record I would like to combine part of two fields (first 3
letters of the Province field and the last 5 digits of the Autonumber primary
key) to form a unique "Stock Number". I used an append query with a
concatinated expression. Every thing works fine except the leading zeros do
no hold their place. e.g. "KAS5" is generated by the query but it shoud be
"KAS00005". How do I get the leading zeros to stay? Dose it have anything
to do with the autonumber being a number and the Stock Number being text?
letters of the Province field and the last 5 digits of the Autonumber primary
key) to form a unique "Stock Number". I used an append query with a
concatinated expression. Every thing works fine except the leading zeros do
no hold their place. e.g. "KAS5" is generated by the query but it shoud be
"KAS00005". How do I get the leading zeros to stay? Dose it have anything
to do with the autonumber being a number and the Stock Number being text?