Richard,
Thanks for your feedback. I think this version of the SQL should work
better when multiple sets of parents are involved.
=================
To find multiple birth siblings using Microsoft Access requires the
following steps.
1) Make a "select query" called "qSiblingInfo" with the following SQL code
to find all records in the Legacy database and extract their RIN, Surname,
GivenName, Birthdate, Parents MRIN, and child status number if they have a
birthdate and parents.
SELECT
tblCR.IDMR,
tblIR.BirthSD,
tblCR.IDIR,
tblIR.Surname,
tblIR.GivenName,
tblCR.IDCPDad,
tblCR.IDCPMom,
tblCR.IDCS
FROM tblIR LEFT JOIN tblCR ON tblIR.IDIR = tblCR.IDIR
WHERE (((tblCR.IDMR)>0) AND ((tblIR.BirthSD)>0));
2) Make a second "select query" called "qFindMultipleBirths" with the
following SQL code to find siblings with same birthdate in the Legacy
database and then show their Parents MRIN, Birthdate, RIN, Surname,
GivenName, child status number, and child status description.
SELECT
qSiblingInfo.IDMR,
qSiblingInfo.BirthSD,
qSiblingInfo.IDIR,
qSiblingInfo.Surname,
qSiblingInfo.GivenName,
qSiblingInfo.IDCPDad,
qSiblingInfo.IDCPMom,
qSiblingInfo.IDCS,
tblCS.ChildStatus
FROM qSiblingInfo INNER JOIN tblCS ON qSiblingInfo.IDCS = tblCS.IDCS
WHERE (((qSiblingInfo.IDMR) In (
SELECT [IDMR] FROM [qSiblingInfo] As Tmp
GROUP BY [IDMR],[BirthSD]
HAVING Count(*)>1 And [BirthSD] = [qSiblingInfo].[BirthSD])))
ORDER BY qSiblingInfo.IDMR, qSiblingInfo.BirthSD;
3) Each set of multiple births should be displayed in adjacent rows. The
child status number can be modified to show the correct child status
description (see tblCS) or a report could be printed and then used to help
in making changes inside of Legacy.
Enter the drawing for a FREE Legacy Cruise to Alaska or a FREE research trip to
Salt Lake's Family History Library. Open to users of Legacy 6 Deluxe. Enter
online at http://legacyfamilytree.com/FreeTrip.asp
Legacy User Group guidelines can be found at:
http://www.LegacyFamilyTree.com/Etiquette.asp
To find past messages, please go to our searchable archives at:
http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/
For online technical support, please visit
http://www.legacyfamilytree.com/Help.asp
To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp
