question

  • Thread starter Thread starter Penny
  • Start date Start date
P

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
 
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
 
Back
Top