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
 

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

query help plz 1
Trim Name? 4
Total numbers by month 2
Problem with Access concatenate query 4
Extracting Initials 3
Problem with query when data removed 3
Dates Subquery 1
Splitting a field 2

Back
Top