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
 
Give this a try ...

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


hth,
 
To Code it in the query use a expression such as the one
below:
Expr1: &Left([First Name],1) & Left([Last Name],1)
 
You must log in or register to reply here.

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

Sometimes there a middle initial 5
Seperate First Name and Last Name 3
Extracting and Separating Names in Access Query 2
Parsing Full Name and Title/degree 7
Parsing inconsistent data 6
if statements in queries 9
Multiple Field Index Problem 4
aggregate function error 7

Back
Top