Base your report on a query that sorts by Last Name but has Visible unchecked in query grid.
Hth
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Russ <grizpatch@twc.com>
Sent: Friday, June 12, 2020 3:28:39 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 3:28:39 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