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

Duane,

I just posted two images and the details of the query results but I do not see them in the Messages area.  I have changed the sort of the query as you have suggested.  See SQL:

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 Nz([SchNm],[LastName]);

Shall I repost the images?

Russ

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

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

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

_._,_._,_