help!

  • Thread starter Thread starter newuser
  • Start date Start date
N

newuser

Hi
I have been given a dataset with data,but the problem is now i need to
create membership cards,which i plan to use the label wizard in reports,but i
also have to display the intials of the customer but i have not been given
the fields for intials just forename and last name.Is there maybe a way of
running a query to search for some of the forename field to use as my
intial????
thanks !
 
I thought I had seen this post a day or two ago and it was answered.

If you want Initial and Last name

Left(FirstName,1) & " " & LastName
 
Back
Top