First initial of name

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

How do I return the first initial of the first name.
Eg. Smith, J

The code presently in the query field:

ClientFullName: [ClientLastName] & ", " & [ClientFirstName]

This is a HIPA issue. I can not show the clients full name
 
Figured it out...sorry if anyone is efforting this request
ClientTrunName: Left([ClientLastName],1) & ", " & [ClientFirstName]
 
Back
Top