query to convert name to initials

[techexpressinc]

I have names in one field and I want it to be initials in a new field. Can someone gave me a push.

Field Name = Tom Smith

Field Initials = TS

I have Name. So, I am thinking it would be:

In the query it would be a new field

Initials: ????

Some Function or Iff statements...


THX
for the Help
Russ

 

[DCrake]

Use the Split() function to pass the ords into an array and lop off the first letter of each item in the array

 

[ghudson]

This should help get you started. Just substitute the comma for a space. Then use the Left() function to grab the first letter.

http://support.microsoft.com/kb/95608

 

[techexpressinc]

Thx for the help I ended up with this:

initial= left(fname,1) & mid(fname,instr(1,fname &" "," ")+1,1)

 

[boblarson]

Also, another good reason why you should store names in Separate fields (first in one, last in another, and middle in another). Then you can even more easily just pull what you want when you want and don't need to worry that someone has a strange name which then makes it hard to parse out.