Initials

[Guest]

I need to something like this

initials: left([First_Name],1) & left([Middle_Name],1) & left([Last_Name],1)

I have a 'Designers' table that has a drop down to pick people from an
'Employees' table to be designers. What I need is to automatically generate
the person’s initials to associate with the jobs they've done. How is the
best way to make this happen?

 

[John W. Vinson]

I need to something like this

initials: left([First_Name],1) & left([Middle_Name],1) & left([Last_Name],1)

I have a 'Designers' table that has a drop down to pick people from an
'Employees' table to be designers. What I need is to automatically generate
the person’s initials to associate with the jobs they've done. How is the
best way to make this happen?

Don't.

Create a Query based on the table instead, and use this expression in a vacant
Field cell. This query can be used as the rowsource of a combo box; there's no
need to store the information redundantly in your table.

If you want to do so anyway, open your Employees table; add an initials field;
and run an Update query updating it to this same expression (less the
"initials:" part).

John W. Vinson [MVP]

 

[Guest]

Oh, I See! (the light bulb comes on)

Thanks John

I need to something like this

initials: left([First_Name],1) & left([Middle_Name],1) & left([Last_Name],1)

I have a 'Designers' table that has a drop down to pick people from an
'Employees' table to be designers. What I need is to automatically generate
the person’s initials to associate with the jobs they've done. How is the
best way to make this happen?

Don't.

Create a Query based on the table instead, and use this expression in a vacant
Field cell. This query can be used as the rowsource of a combo box; there's no
need to store the information redundantly in your table.

If you want to do so anyway, open your Employees table; add an initials field;
and run an Update query updating it to this same expression (less the
"initials:" part).

John W. Vinson [MVP]