question

[Penny]

I have a text box in a report pulling three fields. The
fields are (Last Name, First Name). I would like to be
able to show their initials only. How would I do this?
Below is my code


=[Capital Markets Originator] & "/" & [Capital Markets
Distributor] & "/" & [Capital Markets Jr Support]


Thanks in advance

Penny

 

[Fons Ponsioen]

If I understand correctly I think what you want is:
=Left([Last Name],1)&Left([First Name],1)
If you place this in a textbox make sure the texbox is not
named the same as a variable.
Hope this helps.
Fons