Expression in Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have this field in this Query called LastName. I have also in the same
query the following expression:
LastNameFirstLetter which should pick up the first letter of each Name
entered in the LastName field, but I don’t’t know what to enter in the
expression field to achieve this. So far I have : LastNameFirstLetter:
Format([LastName], but cannot find the rest of expression.
Any help much appreciated.
Chris1.
 
Not sure for your description whether you have single-word LastName,
multiple-word LastName or multiple LastNames in the Field value.

If it is single-word LastName, use Left([LastName], 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

Improving append query speed 1
Use In() Expression as Query criteria with guts from Function 1
Distinguish between same field names in 2 tables 10
Query Expression 5
Year query based on text 3
Hours for month as value in query 7
Remaining Balance Query 2
Parameter Query? 10

Back
Top