Calculated Fields

Resolved · Low Priority · Version Standard

Calculated Fields

Sarah has attended:
Access Intermediate course
Access Intermediate course
Access Advanced course
Project Management course

by - delegate Sarah [8 posts] (2008 Feb 12 Tue, 14:52) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	2	book now	£215	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
2003	2009 Jan 6 Tue	Southwark	5	book now	£198	£215
Full Schedule: See all 51 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Calculated Fields

by - trainer Pete platinum contributer [816 posts] (2008 Mar 18 Tue, 11:04) Reply

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.

· Microsoft Access, an Efficient Database Tool
· Get More Out of MS Access Courses
· The Benefits of Certified Microsoft Training in Access
· Microsoft Access Mistakes to Avoid
· MS Access: Access your Personal Information with Ease

Please browse our web site to find out more about
microsoft-access-course and other Microsoft training courses.

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.