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

Jane I had a similar problem about 4 years ago and, rather than trying to explain it myself, I've cut-and-pasted Simon Orde's words as follows:- Brian used a filter which was intended to exclude everyone born after 1900. But he used a YEAR qualifier when specifying the required date. i.e. INDI.BIRT.DATE:YEAR That may seem like a harmless qualification, but it actually made a significant difference and stopped the filter from doing what was wanted. If you use a YEAR qualifier, you are asking for the year part of the date. For example, if you specify the date as, say, '1st Sept 1940' or as 'approximately 1940', the YEAR qualifier will return the year as 1940. But what is the YEAR if the date is given as 'after 1940'? Or 'between 1940 and 1954'? There isn't one. So when qualified for YEAR, the expression will return no value in these cases. And 'no value' is not later than 1900. So because he used a YEAR qualifier when specifying the date, the filter failed to exclude anyone whose date was recorded as 'after 1940' or 'between 1940 and 1954'. By simply removing the year qualifier for the date expression, the filter does what is required - i.e. INDI.BIRT.DATE Hope this solves the problem. Brian ----- Original Message ----- From: "Jayne Harry" <jayne.h@telus.net> To: <FAMILY-HISTORIAN-USERS@rootsweb.com> Sent: Sunday, February 12, 2012 8:55 PM 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 > > ------------------------------- > To unsubscribe from the list, please send an email to > FAMILY-HISTORIAN-USERS-request@rootsweb.com with the word 'unsubscribe' > without the quotes in the subject and the body of the message

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

One extra word of caution. Many of the Custom Queries like "Census Record Checklist" are often designed to work with UK Census dates not Canadian ones. This one excludes people born after 1902 which would not cover Canadian 1906, 1911, 1916 Census years. 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 Jayne Vancouver Island, Canada GFHS Member 8271