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

Thanks for posting the SQL view. I don't recall the previous messages so I can't provide much assistance. Which field is the "current last name" and which is the maiden name? How do you want to sort the report?

What fields do you want to display in the report?

Regards,

Duane

---

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

 

Here is the SQL view of the query for the deceased report.  SchNm is the last name prior to marriage aka maiden name.

SELECT [First Name] & " "+Nz([SchNm],[LastName]) AS FullName, NameList.LastName, Nz([SchNm],[LastName]) AS SortName, NameList.SchNm

FROM NameList

WHERE (((NameList.Deceased)=Yes))

ORDER BY NameList.LastName, NameList.SchNm;

Re: Sorting and displaying men and women last names and maiden names

Duane, 
Here are 3 images of the report and the query that I am trying to fix.  The way I have it set up the print does not show the current last name of the women who were married.  What am I doing wrong?