Duplicates in query need to NOT be suppressed

[GraeagleBill]

I have a UNION query comprised of three parts. The first part has 2 duplications in the fields you see in RED, which in this case SHOULD NOT be suppressed. When the query runs, only one of the two records are returned. If I run the first section of the query by itself the duplicates are returned. Is there something about UNION queries that cause the suppression? If so, how do I turn it off so that the duplicate(s) are returned?

SELECT DonRegFam.DOE, NameFn([Familyname]) AS Name, DonRegFam.CheckNo, DonRegFam.Amount
FROM Families INNER JOIN DonRegFam ON Families.FamilyID = DonRegFam.FamilyID
WHERE (((DonRegFam.CheckNo)<>""))
UNION SELECT DonRegInd.DOE, NameFn([LastName] & "," & [FirstName]) AS Name, DonRegInd.CheckNo, DonRegInd.Amount
FROM Registry INNER JOIN DonRegInd ON Registry.RegistryID = DonRegInd.RegistryID
WHERE (((DonRegInd.CheckNo)<>""))
UNION SELECT DonUnReg.DOE, NameFn("") AS Name, DonUnReg.CheckNo, DonUnReg.Amount
FROM DonUnReg
WHERE (((DonUnReg.CheckNo)<>""))
ORDER BY name;

[pbaldy]

UNION by itself suppresses duplicates, UNION ALL does not. That also makes it more efficient.

[GraeagleBill]

Got it, thanks.
Bill

[pbaldy]

No problemo.