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

You can create a new column in the report's record source. 

 

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

Sent from my mobile

On Jun 12, 2020, at 7:11 PM, Russ <grizpatch@twc.com> wrote:

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