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

John: If the purpose of purpose of removing people with no BMD data is simply to avoid cluttering the list with people for whom you are not sure whether they were in the right time-frame for a census entry then maybe it goes too far? When I went hunting for missing census entries, I approached the problem slightly differently. I have uploaded to the query store on the FHUG site this morning two similar queries. Both are specific to ancestors of a specified starting person but could easily be modified to deal with all relatives or indeed anyone in the file. You should be able to locate them amongst recent downloads. One query gives the census places for ancestors; the other simply indicates whether i have a census entry in my file for that ancestor. People born after 1911 or with deaths or burials before 1841 are excluded but additionally I used the Ahnentafel function to cut the result off at my 4G-grandparents. This could be adapted for use with relatives other than ancestors, for example by using the RelationCode function - or it may be that in your case the other filters would be sufficient. If either of these two functions gives you something along the lines of what you are looking for, I would be happy to suggest modifications to suit whatever you are seeking to achieve. Derek