I just want first Initial

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
 
C

Cheryl Fischer

Give this a try ...

PersonName: Left([FirstName], 1) & ". " & [LastName]


hth,
 
J

Jess

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