Forum home » Delegate support and help forum » Microsoft Access Training and help » Calculated Fields
|
|
|
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. |
Calculated Fields
Resolved · Low Priority · Version Standard
Reply Tue 12 Feb 2008, 14:52Delegate Sarah said...
Sarah has attended:
Access Intermediate course
Access Intermediate course
Access Advanced course
Project Management course
Calculated Fields
Hi,
I am trying to remember how to create a calculated field such that I create a personal "ID" from the autonumber (which is held in another column) so that they all read (for example) "ABC3554" instead of the simple autonumber of "3554".
Many thanks
For upcoming training course dates see: Pricing & availability
RE: Calculated Fields
Hi Sarah, Thank you for the post, in answer to your question this requires you to create a concatenated field in a query, you will need another field which will hold the prefix we will call this field [prefix] and join this field to the autonumber field, in your query design grid in a blank field enter the following: NewID:[prefix]&[OldID] where NewID: is to be the label and [OldID] your existing autonumber field name. The concatenated field will then be available as an autonumber field in a form or table for new entries. I hope that jogged your memory, best regards Pete.
|