Jump to content
Sign in to follow this  
Rangoon

How to convert Jim Smith to "Smith, J

Recommended Posts

Are both first and last names in one text field?

Create a calculation:

Rightwords (NameField,1) & ", " & Left (NameField,1)

Hope that helps!

Share this post


Link to post
Share on other sites

If you have a choice, create separate fields for the first name and last name. Then your calc would be = LastName & ", " & Left(FirstName,1). This also makes life easier when the person your talking about is Bobbie-Jay Sue Hamilton-Smith III, instead of Fred Jones.

In general, its better to keep your data elements small because this allows you greater flexibility in design. You can always create calc fields later on to combine them in any way you want. This is especially important for addresses, where summary reports by city, postcode, state or country would be difficult if these were all in the one field - but very easy if they were separate.

Share this post


Link to post
Share on other sites

Thanks Russ and Trevorg for your help and yes, I do have first and last names in seperate fields. The calculation works great and does exactly what I need it to.

Russ, How are things in Australia this fine day. I have a friend in the offcie who is from Malta. He has a lot of family in Australia and plans to move there in 5 years. I spend a lot of time with Austrilian Rangers in Vietnam and have the utmost respect for them and our Austrilian friends.

Harry

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.