* Help Querying Census events

[oldtimer47]

Dear All

I'm struggling with what ought to be a simple query.

I have varying numbers of census events against individuals anywhere from 0 to 8 depending when they were alive

What I want to do is show all census entries that do not have an associated source i.e. 'where within source'

I can make this work on the first census entry with the following code

add unless %indi.cens.DATE% is null
exclude unless %indi.cens.sour.page% is null

What I am struggling with is making it also work on the 2nd and subsequent entries. Ideally I would like a list of all unsourced census events across all the census years.

If this isn't possible for any reason I could check a single year (entered via a field) but I don't know how to check all possible 8 census entries for that year.

Any help or suggestions will be much appreciated as always!

Thanks
Peter


ID:4817

[PeterR]

One possibility (probably the simplest) using FH V4 is a Fact Query with the following Column and Row Filter definitions:

[tatewise]

If you also want to include Census (family) events then add the following Row Filter between the other two:

Add if =FactName() matches 'Census (family)'.

Your original posting specifically mentioned 'Where within Source' and your example used Exclude unless %INDI.CENS.SOUR.PAGE% is null.

The equivalent Row Filter for the Fact Query is: Exclude unless %FACT.SOUR.PAGE% is null

[oldtimer47]

Thanks for the quick replies - I'm pleased to say the V4 fact query sorted it out for me once I figured out where to use the different types of brackets

[grin]