* Queries

[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

[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.

[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.

[hsw]

I suspect your query only includes individual census events; you need to add the equivalent family ones as well.

[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?

[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.

[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?

[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.

[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.

[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.