need a formula function 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

[weekend00]

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

this works only for one-word name ( like "smith") or 2-word-name (like "tom smith").
need more to deal with names with more than 2 words.

[techexpressinc]

I had other solutions submitted but this one gets the gold star.

Russ