Employees initials

[billyradd]

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?

 

[Allen Browne]

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.

 

[John W. Vinson]

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]

 

[billyradd]

Thank you very much Allen.

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.

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?

 

[billyradd]

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'.

 

[billyradd]

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

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.

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?

 

[Allen Browne]

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.

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

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?