Simple text box bound to "Name". Control Source is Union query, see SQL:
Code:
SELECT LastName, FirstName, Att, Spouse, SAtt, CYP, [Lastname] & ", " & [FirstName] AS Name
FROM tblMembers WHERE (((Att)=True))
UNION SELECT LastName, FirstName, Att, Spouse, SAtt, CYP, [Lastname] & ", " & [Spouse] AS Name
FROM tblMembers WHERE (((SAtt)=True))
ORDER BY LastName, FirstName;
Run SQL yields:
Notice SQL returns Names: "Bridge, Jack"; "David, Chris" and "Harding, Steve".
I cannot determine "why" those three names DO NOT appear in the report:
The text box has conditional color formatting based on the value found in field CPY:
Nothing really complicated here, but still puzzled as to why all of the "Names" don't appear in the report.