first initial 1

[bkast3]

In some reports I have to list the last name and first initial of their first name or the first name and the first initial of their lastname. I was wondering if there is a formula that will allow me to "pull" the first initial of a last or first name.

 

[Madawc]

If you want the first character of a field, then
left({Your.field}, 1)
Is that what you were after?

You can also have a formual field that combines them, e.g.
{As.lastname} & ", " & left({As.firstname}, 1)
Or make it more elaborate, test a name for being spaces or null, there are usually some

Madawc Williams (East Anglia, UK)