* Query to find Grandmothers

[E Wilcock]

Is it possible to design a query in fh that would find the women who have grandchildren in a multi family Project - a place study?

I see there is a query to find closest relations - Could that be customised to find grandchildren?

[Jane]

You can't use closest relations as it's based on a single person.

I have done a quick query which checks the first 6 children for children. You can change to include more children as needed.

[E Wilcock]

Jane Thank you.

That is amazing. In more ways than one - I felt ashamed asking but I have read how you did it - and alongside the Help page have learned something about writing queries.
I have industriously entered more than 4,000 people in fh - with my eye on emigration. And have been pretty sure that I can extract the information. But the possibility that my Project might also have information about grand mothers, occurred to me only yesterday in the archives.

Thank you for the query to find them. I wasnt at all sure it would be possible. And the way you set out the columns child by child shows more about Grandmothers than I expected.
I had been very conscious that each nuclear family of parents and children has two grandmothers, but hadnt been so aware of the other view that one woman may be grandmother in several different families.

I am very grateful.

[ronniemacleod]

I was looking for a query to find grandchildren and grandparents by name and thought I could use this as a basis and modify it but when I run it I get an error message "file is not a valid family historian query file" - I had the same problem with another query called "Grandchild list" Are these incompatible with v5.0.9?

[Jane]

Installed fine when I loaded it into 5.0.11, might be worth installing the 5.0.11 upgrade.

https://www.family-historian.co.uk/down ... ad-archive

[tatewise]

First of all V5.0.9 is not the latest free version and should be updated to V5.0.11 anyway.

If Query still does not run, it is due to new shortcuts such as %INDI.~CHIL[2]% introduced with FH V6.
That returns the 2nd Child by any Family partnership.
So it could be the same person as %IND.FAMS[1]>CHIL[2]% if the 1st Family had two or more children.
But, it could also be the same as %IND.FAMS[2]>CHIL[1]% if the 1st Family had just one child.
Or even it could be the same as %IND.FAMS[3]>CHIL[2]% if the 1st & 2nd Families had no children.

So you could get the Query to work, but you would need a lot more Columns and complex Row filters.
If you desperately need such a Query then we can advise what you need.