Page 1 of 1
Queries
Posted: 05 Jun 2010 09:23
by Stratton52
I have been using Family historian since V3 but never managed to master queries. Thanks to your brilliant tutorial I have now managed to create queries for all the censuses, and insert the relevant flags into diagrams.
I have always entered census info as an event; I enter the parents as a family event, and then enter the information for each child separately. All the entries are there when I look under the FACT tab, but are not all showing in the query result. It appears that couples entered under the 'Census (family)' facility are not recognised.
Am I doing something wrong?
Jean
ID:4606
Queries
Posted: 05 Jun 2010 11:52
by Stevebye
Have you tried Nick Walker's excellent program Ancestral Sources for entering Census details. It's free and avaliable from the FHUG Home Page, (Right-hand side of page).
It removes all the hard work and is a doddle to use.
Queries
Posted: 05 Jun 2010 12:00
by Stratton52
Yes, I downloaded it last week and shall use it in future. It looks brilliant. But that doesn't solve the issue with the entries I have done previously.
Queries
Posted: 05 Jun 2010 12:39
by hsw
I suspect your query only includes individual census events; you need to add the equivalent family ones as well.
Queries
Posted: 05 Jun 2010 15:01
by Stratton52
I knew there would be some clever person out there! I have indeed created a query for an individual. I presume I will have to create two separate queries, then add them both to the same list - ie. it is not possible to catch both groups with one query?
Queries
Posted: 05 Jun 2010 16:03
by hsw
It should be possible catch both groups with a single query. How have you constructed you current query -- by adding individuals with a fact for the relevant census year? If so, you just need to add the individuals with a family fact for that census year as well.
Queries
Posted: 05 Jun 2010 16:17
by Stratton52
Thanks for your help. I am wading in unfamiliar waters. My query was INDI.CENS[year=1841]. I can see how to construct FAM.CENS[year=1841]. The couples come up OK but I now see that you can only attach a flag to an individual. Am I going to have to sort this out the long way?
Queries
Posted: 05 Jun 2010 16:45
by hsw
I haven't been able to test this as I don't have any family census records, but the following should work as an Individual query.
Code: Select all
Add unless %INDI.CENS[year=1841]% is null
Add unless %INDI.FAMS>CENS[year=1841]% is null
If you have individuals who married more than once, you can add further lines like
Code: Select all
Add unless %INDI.FAMS[2]>CENS[year=1841]% is null
Add unless %INDI.FAMS[3]>CENS[year=1841]% is null
and so on up to the maximum number of marriages you expect an individual to have had.
Queries
Posted: 06 Jun 2010 10:16
by Stratton52
Thanks very much for your help. Although I recognise that your suggestion would work in an Excel document, FH asks you to choose between Individual and Family, and won't recognise it.
Never mind. I solved the problem in the end by doing a separate Family Query, adding the results to the Named List of Individuals ... and then going through the Family records putting each member on as an Individual. I got the whole lot done in an hour, so reckoned it was quicker than trying to solve it by trying to be clever!
From here on I shall make sure I use Ancestral Sources, so the issue won't arise again.
Queries
Posted: 06 Jun 2010 11:29
by hsw
That's odd -- it works fine for me; and I created an 1841 family census event as well to check.
Still, you've solved your problem, which is th eimportant thing.