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
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?
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?
Tidak ada komentar:
Posting Komentar