Pick up first letter

[rogerarce]

I have created a table with names and address of customers in it. I have their firstname and lastname but want to create labels. How can I get only the first letter of their firstname and lastname to I can either store it in a field in the table when new people are entered etc., so I can pick it up for use in letters and labels? For example:

Current value : John Smith value for Letter/Label : JS


Thanks for your help!

 

[randy700]

The first and last names should be stored in separate fields. Then, simply use the LEFT function.
If the full name is in one field and, for some reason, cannot be corrected, take a look at the MID and INSTR functions.


Randy

 

[rogerarce]

Thanks Randy