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
[tblIR].[IDIR],
[tblIR].[Surname],
[tblIR].[GivenName],
[tblIR].[BirthSD],
[tblIR].[IDMRParents],
[tblCR].[IDCS]
FROM tblIR
LEFT JOIN tblCR
ON [tblIR].[IDIR]=[tblCR].[IDIR]
WHERE ([tblIR].[BirthSD]>0 And [tblIR].[IDMRParents]>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.IDMRParents,
qSiblingInfo.BirthSD,
qSiblingInfo.IDIR,
qSiblingInfo.Surname,
qSiblingInfo.GivenName,
tblCR.IDCS,
tblCS.ChildStatus
FROM qSiblingInfo
INNER JOIN (tblCS INNER JOIN tblCR ON tblCS.IDCS = tblCR.IDCS)
ON qSiblingInfo.IDIR = tblCR.IDIR
WHERE (((qSiblingInfo.IDMRParents) In (
SELECT [IDMRParents] FROM [qSiblingInfo] As Tmp
GROUP BY [IDMRParents],[BirthSD]
HAVING Count(*)>1 And [BirthSD] = [qSiblingInfo].[BirthSD])))
ORDER BY qSiblingInfo.IDMRParents, 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
