Adding a comma after a field

L

LG

If i am using =([F_Name] + " ") & [L_Name] this in a text box how would I be
able to add a comma after the L_name when it addresses the member?
Ex currently the above produces John Smith I would like it to have the
result of John Smith,
Thank you
 
J

Jerry Whittle

=[F_Name] & " " & [L_Name] & ","

I avoid using the + sign to join fields as it can get confusing if numbers
are involved.
 

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

Top