John Have you looked at the Query <http://www.fhug.org.uk/cgi-bin/index.cgi?action=downloads&cat=queries> downloads section of the FHUG (www.fhug.org.uk) website? There may well be something very close to your requirements, that you could adapt, there already. HTH John _____ From: family-historian-users-bounces@rootsweb.com [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of APhill1274@aol.com Sent: Thursday, August 25, 2011 8:26 AM To: family-historian-users@rootsweb.com Subject: Re: [FHU] Query setup further.. Thank you for your help. Between yourself and Jane it has been educational. What I hoped to achieve was a list of all persons in the database which were then sorted to exclude the following:- All those persons born and died before 1841 All those persons who were born after 1911 All those persons who have no birth marriage or death data ie had name only. This would then produce a results list that one could see any omissions of individual census years. I am a little confused now whether Janes version or yours fulfills ALL of the requirements above. Do I have to rewrite again ?? Would it be too much to ask if this complete query could be written and called say" Census missing (3)" or something similar. I am sure this would be useful to other people using FH as well as myself. Once again thanks to you both. John In a message dated 24/08/2011 19:28:58 GMT Daylight Time, post@tatewise.co.uk writes: This should work better - the Boolean logic needed to be inverted. Add the following Row to exclude anyone with no birth date and no marriage date no death date. Exclude if =Bool( Not(Exists(%INDI.BIRT.DATE%)) and Not(Exists(%INDI.FAMS[1]>MARR[1].DATE%)) and Not(Exists(%INDI.DEAT.DATE%)) ) is true Regards, Mike Tate -----Original Message----- From: family-historian-users-bounces@rootsweb.com [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of APhill1274@aol.com Sent: 24 August 2011 16:50 To: family-historian-users@rootsweb.com Subject: Re: [FHU] Query setup further.. Thanks Jane All went in ok but still leaves showing in the results, the non birth non marriage non death persons. Is there a way I can send you the query for you to test why ?? How do I copy a query to send to you or anyone Thanks for being patient John In a message dated 24/08/2011 15:54:51 GMT Daylight Time, janetaubman@gmail.com writes: Sorry should be =Bool(Exists(%INDI.BIRT.DATE%) or Exists(%INDI.FAMS[1]>MARR[1].DATE%) or Exists(%INDI.BIRT.DATE%)) On 24 August 2011 15:35, <APhill1274@aol.com> wrote: > you mention 2 > INDI.BIRT and one INDI.DEAT but no INDI. marriage ?? Jane. ------------------------------- 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 ------------------------------- 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 _____ avast! <http://www.avast.com> Antivirus: Inbound message clean. Virus Database (VPS): 24/08/2011 Tested on: 25/08/2011 08:29:23 avast! - copyright (c) 1988-2011 AVAST Software. _____ avast! Antivirus <http://www.avast.com> : Outbound message clean. Virus Database (VPS): 24/08/2011 Tested on: 25/08/2011 08:32:06 avast! - copyright (c) 1988-2011 AVAST Software.

FYI That is where John started - using the Query "Census Missing Years 1911" He wants to filter out everyone who died before 1841 or who were born after 1911 or who have no Birth nor Marriage nor Death date. These E-mails are related to FHUG Forums > General > "amend census custom query" thread at http://www.fhug.org.uk/cgi-bin/index.cgi?action=forum&board=General&op=display&num=5388 where these filters have been discussed. Not sure why John has switched to FH Mailing List. The three filters that must all be added together to the Rows tab are: Exclude if %INDI.DEAT[1].DATE% was earlier than 1841 Exclude if %INDI.BIRT[1].DATE% was later than 1911 Exclude if =Bool(Not(Exists(%INDI.BIRT.DATE%)) and Not(Exists(%INDI.FAMS>MARR.DATE%)) and Not(Exists(%INDI.DEAT.DATE%))) is true Or, if you prefer, that last filter can be: Exclude unless =Bool(Exists(%INDI.BIRT.DATE%) or Exists(%INDI.FAMS>MARR.DATE%) or Exists(%INDI.DEAT.DATE%)) is true But remember the Date earlier/later than tests do not work for 'Date Phrases' unless you use the '...interpreted as:' option. Regards, Mike Tate -----Original Message----- From: family-historian-users-bounces@rootsweb.com [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of John James Sent: 25 August 2011 08:32 To: family-historian-users@rootsweb.com Subject: Re: [FHU] Query setup further.. John Have you looked at the Query <http://www.fhug.org.uk/cgi-bin/index.cgi?action=downloads&cat=queries> downloads section of the FHUG (www.fhug.org.uk) website? There may well be something very close to your requirements, that you could adapt, there already. HTH John _____ From: family-historian-users-bounces@rootsweb.com [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of APhill1274@aol.com Sent: Thursday, August 25, 2011 8:26 AM To: family-historian-users@rootsweb.com Subject: Re: [FHU] Query setup further.. Thank you for your help. Between yourself and Jane it has been educational. What I hoped to achieve was a list of all persons in the database which were then sorted to exclude the following:- All those persons born and died before 1841 All those persons who were born after 1911 All those persons who have no birth marriage or death data ie had name only. This would then produce a results list that one could see any omissions of individual census years. I am a little confused now whether Janes version or yours fulfills ALL of the requirements above. Do I have to rewrite again ?? Would it be too much to ask if this complete query could be written and called say" Census missing (3)" or something similar. I am sure this would be useful to other people using FH as well as myself. Once again thanks to you both. John In a message dated 24/08/2011 19:28:58 GMT Daylight Time, post@tatewise.co.uk writes: This should work better - the Boolean logic needed to be inverted. Add the following Row to exclude anyone with no birth date and no marriage date no death date. Exclude if =Bool( Not(Exists(%INDI.BIRT.DATE%)) and Not(Exists(%INDI.FAMS[1]>MARR[1].DATE%)) and Not(Exists(%INDI.DEAT.DATE%)) ) is true Regards, Mike Tate -----Original Message----- From: family-historian-users-bounces@rootsweb.com [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of APhill1274@aol.com Sent: 24 August 2011 16:50 To: family-historian-users@rootsweb.com Subject: Re: [FHU] Query setup further.. Thanks Jane All went in ok but still leaves showing in the results, the non birth non marriage non death persons. Is there a way I can send you the query for you to test why ?? How do I copy a query to send to you or anyone Thanks for being patient John In a message dated 24/08/2011 15:54:51 GMT Daylight Time, janetaubman@gmail.com writes: Sorry should be =Bool(Exists(%INDI.BIRT.DATE%) or Exists(%INDI.FAMS[1]>MARR[1].DATE%) or Exists(%INDI.BIRT.DATE%)) On 24 August 2011 15:35, <APhill1274@aol.com> wrote: > you mention 2 > INDI.BIRT and one INDI.DEAT but no INDI. marriage ?? Jane. ------------------------------- 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 ------------------------------- 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 _____ avast! <http://www.avast.com> Antivirus: Inbound message clean. Virus Database (VPS): 24/08/2011 Tested on: 25/08/2011 08:29:23 avast! - copyright (c) 1988-2011 AVAST Software. _____ avast! Antivirus <http://www.avast.com> : Outbound message clean. Virus Database (VPS): 24/08/2011 Tested on: 25/08/2011 08:32:06 avast! - copyright (c) 1988-2011 AVAST Software. ------------------------------- 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