Thanks Mike, Adding the extra rows, one for each census fact did solve the problem and now all the relevant individuals are listed. Best regards, Jayne ----- Original message ---------------------------------------- From: "Beryl & Mike Tate" <post@tatewise.co.uk> To: jayne.h@telus.net; family-historian-users@rootsweb.com Received: 12/02/2012 2:26:48 PM Subject: RE: [FHU] Individuals missing from custom query result >Have you checked how many Census Facts these Individuals have? >You Row Filter is only testing the 1st Census Fact %INDI.CENS[1]%. >You also need to cater for %INDI.CENS[2]% and %INDI.CENS[3]% >and so on up to %INDI.CENS[9]%. >I assume you will eventually want to repeat this exercise for every >Census year from 1851 to 1911 and maybe 1906 & 1916. >Some Individuals may be alive for every one of these years and thus >may have 9 Census Facts. >I would check Birth Date versus Census Date rather than the Year. >Also remember to exclude Individuals with a Death Date earlier than >Census Date. >Are you aware of the free utility Ancestral Sources that offers not only >a convenient way to enter Census and Baptism (and soon >Marriage) details but also helps manage your Flags. >Regards, Mike Tate >-----Original Message----- >From: family-historian-users-bounces@rootsweb.com [mailto:family- >historian-users-bounces@rootsweb.com] On Behalf Of Jayne Harry >Sent: 12 February 2012 20:55 >To: FAMILY-HISTORIAN-USERS@rootsweb.com >Subject: [FHU] Individuals missing from custom query result >Hi Everyone, >I made custom queries for each census year to help clear old flags >and set new ones. When I run each query the results look good. >For example, running the 1891 query gives me a list of individuals with >birth dates before 1891 and the census date column shows the >1891 date for all individuals. I used the "clear flag on result set" but >noticed that the flags set on an individual were still >showing in the property box against his name. When I checked the >results list from the query, he is not on it (and there are a >couple of others who aren't , but should be.) >I checked to make sure they had the census details in the "fact" box >and this is ok. They have birth dates in the right place (he >was born in 1859) I can't work out why he isn't showing in the query >results. These are my parameters in the query" >Birth Date: %INDI.BIRT[1].DATE% >Census Date: %INDI.CENS[1].DATE% >Add if %INDI.BIRT[1].DATE:YEAR% was earlier than 1891 >Exclude unless %INDI.CENS[1].DATE:YEAR% was on 1891 >He doesn't show in any of my custom census queries, but I ran the >standard query "Census Record Checklist" and he showed up ok in >that for 1861, 1871, 1881, 1891, 1901. >Obviously I have overlooked something, can anyone help please? >Best Regards, >Jayne >Vancouver Island, Canada >GFHS Member 8271 >