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

Russ,

You really need to figure out how to include the previous messages with your replies. We should not have to go searching to find out what has transpired.

This was your SQL view from a few posts back:

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]);

I gave you this answer several days ago:

FullName: [FirstName] & " " + [MaidenName] & " " & [LastName]

Based on your actual field names, this would be:

FullName: [First Name] & " " + [SchNm] & " " & [LastName]

Regards,

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Russ <grizpatch@twc.com>
Sent: Monday, June 15, 2020 11:02 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Sorting and displaying men and women last names and maiden names

 

Duane,
What I was trying to do is display the prevously married women with First Name then School Name then Last Name.  What it is showing is First Name and School Name.