Hi Ron,
This pair of querys works great.
I first tried it on my small db with 2 sets of twins. When I tried to view
the second query in database mode it said "Query must have at least one
destination field". I had previously identified them as twins in Legacy.
When I put them in a copy of main db I got 312 records. I was able to able
to look them over and verify and identify 150 pairs of twins and found 2
sets of triplets which I also marked in Access. I was able to do all this in
less than an hour. It would have taken weeks in Legacy using the list.
Thank you very much,
=================
Richard Van Wasshnova
Seal Beach, CA
----- Original Message -----
From: "Ron Taylor" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Saturday, May 06, 2006 5:56 PM
Subject: Re: [LegacyUG] Using Access to find twins, triplets, etc.
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.
<snip>
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
