Print only first letter of name on report

Fisher

Registered User.
Local time
Today, 22:42
Joined
Dec 17, 2003
Messages
28
Hello. I'm sure this is a relatively easy question but I seem to be having trouble with it. We have a database of patients participating in studies. At times we would like to email certain reports. Due to confidentiality reasons we do not want to send patient names by email. How can I print only the first letter of the fields containing the first name and last name (initials) on the report?
 
The Left() function.
 
I have used =Left([LastName],1). Thank you for such a rapid reply. I am still learning (obviously) and this forum is always a tremendous resource.
 
No problem. To get the initials, you can put them together:

=Left([FirstName],1) & Left([LastName],1)
 

Users who are viewing this thread

Back
Top Bottom