In many databases, separate fields are used for first and last name. In such cases, this could be your initials calculation:
Left ( Firstname ; 1 ) & Left ( Lastname ; 1 )
If you put both names in the same field, this can still be done, but then you have more variatations in format to deal with, such as the inclusion of middle names or initials.
Left ( Leftwords ( namefield ; 1 ) ; 1 ) & Left ( Rightwords ( namefield ) ; 1 ) ; 1 )
Might work, but you'll need to check it with real examples of the type and format of text you choose to permit with your databaes design.
thnx phil ur a freakin wizard at this!