98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Access
Access
Resolved · Medium Priority · Version 2003
Tue 14 Sep 2010, 08:36Delegate Julie said...
Julie has attended:
Excel Intermediate course
Access Introduction course
Access
In the field with auto numbers can you have an alpha character before the number?
Wed 15 Sep 2010, 09:33Trainer Simon said...
RE: Access
Hi Julie,
Thank you for your question.
In the properties box of the autonumber field, click into format and type something like this:
P0
P0 - this means it will put a P in front of every record and then the unique number.
I hope this answers your question.
Regards
Simon
Attached files...
Autonumberwithtext.mdbWed 15 Sep 2010, 11:27Delegate Julie said...
RE: Access 2003
I have tried this but all it puts in the the PO it is not followed by a number?
Thu 16 Sep 2010, 09:17Trainer Simon said...
RE: Access 2003
Hi Julie,
Thank you for your response.
Did you type a P followed by a zero in the Format property of the autonumber field?
I tested it yesterday with an autonumber field and it worked.
Please find attached a small database with the format line included.
I hope this helps.
Regards
Simon
Thu 16 Sep 2010, 10:14Delegate Julie said...
RE: Access 2003
Thank you that worked. I have another question can you get auto numbers to start at 001?
Thu 16 Sep 2010, 13:17Trainer Simon said...
RE: Access 2003
Hi Julie,
Thank you for your response.
In the format property add two more zeros:
e.g. P000
Each 0 represents the number of characters you need.
That should do the trick.
I hope this answers your question.
Regards
Simon
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Remove spaces in a tableIf you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks |
