Query to use first initial of name only

[headlock]

Hi there, I want to make labels. (That much I can do and can cantonate the first and last names ok thanks to previous helps from this site). I need to be able to have lastname, Firstname with only the first name initial not the whole name & secondname again with only the first initial like such....Myname, N. & L. My question is how do I get that in a query? Is there even such a thing to be able to do that? Thanks for all your help.

 

[G37Sam]

You need to look at the left() function

http://www.techonthenet.com/access/functions/string/left.php

 

[headlock]

Yes, but how do I put it all together in a query. I can get it to do one name eg....
Labels: Left([First Name],1)
But am not sure how to word the whole query with ...Mylastname, N. & L. I can do a code that gives me Mylastname, Firstname & Secondname but I only want the first initials for both Firstname & Secondname. I can't seem to put them all in a code with Left without an error.

 

[headlock]

Ok, figured it out thank you. I hadn't put the brackets in the right place hence the error.