S
Stephanie
Hello. I have a union query that returns the correct records. I want a
count of how many records are brought back. After moving to a union query
I'm having problems getting a count. I'd appreciate suggestions. Thanks.
SELECT [LastName] & ", " & Nz([NickName],[FirstName]) AS [Member Name],
Contacts.ContactID
FROM Contacts INNER JOIN (Groups INNER JOIN GroupMembers ON Groups.GroupID =
GroupMembers.GroupID) ON Contacts.ContactID = GroupMembers.ContactID
WHERE (((Groups.GroupName)="Board of Directors") AND
((GroupMembers.GMemberEnd) Is Null));
UNION SELECT [LastName] & ", " & Nz([NickName],[FirstName]) AS [Member
Name], Contacts.ContactID
FROM Contacts
WHERE (((Contacts.MemberOption)=1) AND ((Contacts.MemberStatusID) In (1,6))
AND ((Contacts.MemberTypeID) In (1,5)));
count of how many records are brought back. After moving to a union query
I'm having problems getting a count. I'd appreciate suggestions. Thanks.
SELECT [LastName] & ", " & Nz([NickName],[FirstName]) AS [Member Name],
Contacts.ContactID
FROM Contacts INNER JOIN (Groups INNER JOIN GroupMembers ON Groups.GroupID =
GroupMembers.GroupID) ON Contacts.ContactID = GroupMembers.ContactID
WHERE (((Groups.GroupName)="Board of Directors") AND
((GroupMembers.GMemberEnd) Is Null));
UNION SELECT [LastName] & ", " & Nz([NickName],[FirstName]) AS [Member
Name], Contacts.ContactID
FROM Contacts
WHERE (((Contacts.MemberOption)=1) AND ((Contacts.MemberStatusID) In (1,6))
AND ((Contacts.MemberTypeID) In (1,5)));