|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 17th, 2007, 02:32 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Employees initials
What would be the easiest way to pluck the first letter from each persons
first, middle and/or last name and put it together as the person’s initials? 
|
|
#2
August 17th, 2007, 06:00 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Employees initials
Type an expression like this into the Field row in query design:
Initials: Left([FirstName],1) & Left([MiddleName],1) & Left([Surname]) Substitute your field names inside the square brackets. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "billyradd" wrote in message news  What would be the easiest way to pluck the first letter from each persons first, middle and/or last name and put it together as the person’s initials?
|
|
#3
August 17th, 2007, 05:11 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Employees initials
On Thu, 16 Aug 2007 18:32:01 -0700, billyradd
wrote: What would be the easiest way to pluck the first letter from each persons first, middle and/or last name and put it together as the person’s initials? So you can get Jim G. Smith and Jane G. Sanderson both being displayed as JGS? How would you want such duplicates handled? John W. Vinson [MVP]
|
|
#4
August 19th, 2007, 12:40 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Employees initials
Thank you very much Allen.
"Allen Browne" wrote: Type an expression like this into the Field row in query design: Initials: Left([FirstName],1) & Left([MiddleName],1) & Left([Surname]) Substitute your field names inside the square brackets. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "billyradd" wrote in message news What would be the easiest way to pluck the first letter from each persons first, middle and/or last name and put it together as the person’s initials?
|
|
#5
August 19th, 2007, 12:50 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Employees initials
Very good question.
But in this situation is really a non-issue; It is very typical in the drafting and design industries to use initials to describe an individual. Even in very large manufacturaing facilities there are rearly more than 50 to 200 people in one dicipline and the chances of the initials matching are quite slim but still poosible none-the-less. The company I work for has roughly 50 people on the payroll and all of the companies we deel with use initials to represent the 'designer', 'checker' & 'sales_rep'. "John W. Vinson" wrote: On Thu, 16 Aug 2007 18:32:01 -0700, billyradd wrote: What would be the easiest way to pluck the first letter from each persons first, middle and/or last name and put it together as the person’s initials? So you can get Jim G. Smith and Jane G. Sanderson both being displayed as JGS? How would you want such duplicates handled? John W. Vinson [MVP]
|
|
#6
August 19th, 2007, 07:36 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Employees initials
Sorry but I'm not exactly sure where I am supposed to put this, could you be
a little more specific? "Allen Browne" wrote: Type an expression like this into the Field row in query design: Initials: Left([FirstName],1) & Left([MiddleName],1) & Left([Surname]) Substitute your field names inside the square brackets. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "billyradd" wrote in message news What would be the easiest way to pluck the first letter from each persons first, middle and/or last name and put it together as the person’s initials?
|
|
#7
August 19th, 2007, 12:55 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Employees initials
Create a query.
Use your table. Type it in the Field row. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "billyradd" wrote in message news Sorry but I'm not exactly sure where I am supposed to put this, could you be a little more specific? "Allen Browne" wrote: Type an expression like this into the Field row in query design: Initials: Left([FirstName],1) & Left([MiddleName],1) & Left([Surname]) Substitute your field names inside the square brackets. "billyradd" wrote in message news What would be the easiest way to pluck the first letter from each persons first, middle and/or last name and put it together as the person’s initials?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
