[MSAccessProfessionals] Sorting and displaying men and women last names and maiden names

This seems tricky to me.   I have records of men and women in a table.  The married women have both last names and maiden names.  The unmarried women and men have just the last name.
To display them in a report I would like to sort them by their original last name but also displaying their maiden name (original for women) in between the first and last name.  Got any ideas?

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

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

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

_._,_._,_