I just want first Initial

  • Thread starter Thread starter Joyce
  • Start date Start date
J

Joyce

I want to display names on a report, but I just want the
first initial of the first name and then the last name.
I've cancatinated the names, but how do I get just hte
first initial to display instead of the entire name. My
field names are "firstName" and "Last Name"

Thank you
 
To Code it in the query use a expression such as the one
below:
Expr1: &Left([First Name],1) & Left([Last Name],1)
 
Back
Top