Employees initials

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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?
Click to expand...

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]
 
Thank you very much Allen.

Allen Browne said:
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

Reply to group, rather than allenbrowne at mvps dot org.

billyradd said:
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?
Click to expand...
Click to expand...
 
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'.
 
Sorry but I'm not exactly sure where I am supposed to put this, could you be
a little more specific?

Allen Browne said:
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

Reply to group, rather than allenbrowne at mvps dot org.

billyradd said:
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?
Click to expand...
Click to expand...
 
Create a query.

Use your table.

Type it in the Field row.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

billyradd said:
Sorry but I'm not exactly sure where I am supposed to put this, could you
be
a little more specific?

Allen Browne said:
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 said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top