[MSAccessProfessionals] Split full name into first and last fields

I have a field called TenantName and it contains the full name of the tenant in this format: Doe, Jane

I need to split the first  name and the last name into separate fields called FirstName and LastName.

Any ideas?

Thank you,

Art Lorenzini
Sioux Falls, SD

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#115532) | Reply To Group | Reply To Sender | Mute This Topic | New Topic

Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_