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)
 
Back
Top