Forum home » Delegate support and help forum » Microsoft Access Training and help » Access
|
|
|
The UK's most regular 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
Resolved · Medium Priority · Version 2003
Reply 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?
For upcoming training course dates see: Pricing & availability
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.mdbReply Wed 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?
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
Reply 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?
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
|