First letter of text in field

[Frazer]

Is there anyway I can run a calculation which looks at a field and copies across the first letter of each word?

In essence I have a field of names and I want to run a calc which will convert this into initials.

Thanks

[dspires]

If your field is "Name", the this will do it:

Left(LeftWords(Name,1),1) &

Left(MiddleWords(Name,2,1),1) &

Left(MiddleWords(Name,3,1),1)

[Frazer]

Thanks,

Works a treat!

[Vaughan]

Not all names are in "First Middle Last" format, so this will not be reliable under all circumstances.

Ideally the first middle and last names should be in separate fields.