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

Hi Russ,

Please keep the previous messages from the thread in your reply.

You can sort by this expression:

Nz([Maiden Name],[Last Name])

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Russ <grizpatch@twc.com>
Sent: Friday, June 12, 2020 4:07 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Sorting and displaying men and women last names and maiden names

 

"Sorting and displaying men and women last names and maiden names"

Yes Duane I have done that but how can I sort them by their original name?  You know, sorted by Last name of the men and at the same time sort them by the maiden name while displaying the women by first, maiden, last.

Russ