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? 

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#115597) | Reply To Group | Reply To Sender | Mute This Topic | New Topic

Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_