First initial of name

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
 
J

Jeff

Figured it out...sorry if anyone is efforting this request
ClientTrunName: Left([ClientLastName],1) & ", " & [ClientFirstName]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing the most recent record for each client 8
How to fix spaces between last name comma first name 8
Auto expand not working with comma 2
Finding partial matched duplicates across two fields 2
First Name Variations - Split MI from First Name 4
reformatting a name 2
Name Parsing 2
Left, LTrim, or what 4

Top