Brian, Thanks for your help. I don't think this is my problem because the individual has his birth entered as dd/mmm/yyyy. I tried it anyway, just in case, because I am no computer whizz. I removed the "year" from my query line, but it still didn't work. There were still a few people missing from the results that they should have been included in. Best regards, Jayne ----- Original message ---------------------------------------- From: "Brian Horridge" <brian.horridge@btinternet.com> To: jayne.h@telus.net; family-historian-users@rootsweb.com Received: 12/02/2012 2:13:56 PM Subject: Re: [FHU] Individuals missing from custom query result >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? >> ------------------------------- >> 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