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

That's how I handle it in all my applications for clients. Works just fine.

Ben Sevier

Sevier Consulting Group

(858) 449-0194

bsevier@sevierconsulting.net

On Jun 12, 2020, at 10:24, Duane Hookom <duanehookom@hotmail.com> wrote:

Hi Russ,

You can create a new column in your query (or expression in a Control Source)

FullName: [FirstName] & " " + [MaidenName] & " " & [LastName]

If maiden name is null then there will still be only one space between first and last names.

Regards,

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Russ <grizpatch@twc.com>
Sent: Friday, June 12, 2020 2:28 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [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?