Page 1 of 1
Blood relatives
Posted: 02 Feb 2005 19:24
by alvinshipperley
Is there any query or report that lists just blood relatives (ancestors and descendants) of a selected person? I want to find out all the surnames that I'm related to directly.
ID:770
Blood relatives
Posted: 02 Feb 2005 23:00
by Jane
The easiest way is to simply create a new query adding all descendant and all ancestors for the same person.
If you are not confident on what to do just post a reply and I will load one on to the site for you.
Blood relatives
Posted: 02 Feb 2005 23:10
by alvinshipperley
Thanks, but I suppose I mean more than just direct relations, eg. my great-grandfather had a daughter who married a Green and their daughter married a Hale and had a son - therefore, I am related to some Hales out there.
I would appreciate some direction.
Blood relatives
Posted: 03 Feb 2005 08:36
by Jane
Thats fairly simple just use the All relatives query. If you save it as a custom query and add a column for the surname and save the results if you have excel you can use a pivot table to quickly produce a 'short list' of all the surnames with a person count for each name.
Blood relatives
Posted: 03 Feb 2005 10:09
by alvinshipperley
Thank you. I don't use Queries much so I appreciate the help.
I managed to create a custom query from the one you recommended and it gives what I need.