Further to recent posts on this topic I tried it. First of course you have to add %FACT.SOUR[1]>% to the columns of the basic query - when I did this it reduced my total facts from 11,156 to 4,483 - still rather a lot of facts without sources. But what I do when for example I have a FreeBMD entry is to write a note on the fact (rather than a source entry) on the premise that it isn't a cast iron source record. So what I ten did was to add the fact note to the columns of the custom query (%FACT.NOTE2[1]%) and then a further filter of "Exclude unless %FACT.NOTE2[1]% is null". This brought my results down to 1,702. Rather horrifying number of facts without any explanation and it gives me something to work on. Thanks for the idea. Dick Thomas

I have been following this with interest, and have found to my horror that I have over 3000 unsourced facts, of which around 10% are family-related but the majority individual. What I would like to do, but haven't managed to find how, is to provide an additional filter for the individual fact owners, to give me all of the ones who are direct ancestors of the root (or of a given person if root isn't possible). I realise I can sort by fact owner but with that number picking out direct ancestors still isn't very easy. Are there any functions etc which can work on fact owner in this way? Thanks in advance for any help/suggestions.   Regards, Andrea ________________________________ From: "Thomasatelmers@aol.com" <Thomasatelmers@aol.com> To: family-historian-users@rootsweb.com Sent: Monday, 16 January 2012, 9:08 Subject: [FHU] Advice re lack of source material Further to recent posts on this topic I tried it. First of course you have  to add %FACT.SOUR[1]>% to the columns of the basic query - when I did this it  reduced my total facts from 11,156 to 4,483 - still rather a lot of facts  without sources. But what I do when for example I have a FreeBMD entry is to  write a note on the fact (rather than a source entry) on the premise that it  isn't a cast iron source record. So what I ten did was to add the fact note to  the columns of the custom query (%FACT.NOTE2[1]%) and then a further filter of  "Exclude unless %FACT.NOTE2[1]% is null". This brought my results down to 1,702.  Rather horrifying number of facts without any explanation and it gives me  something to work on. Thanks for the idea. Dick Thomas ------------------------------- 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

On 16 January 2012 16:56, Andrea Kent <andrea.kent@btopenworld.com> wrote: > What I would like to do, but haven't managed to find how, is to provide an additional filter for the individual fact owners, to give me all of the ones who are direct ancestors of the root (or of a given person if root isn't possible). I realise I can sort by fact owner but with that number picking out direct ancestors still isn't very easy. Are there any functions etc which can work on fact owner in this way? This should work Exclude Unless =IsAncestorOf(FactOwner(%FACT%,1,MALES_FIRST),FileRoot()) -- Jane. Jane Taubman | www.rjt.org.uk | www.taubman.org.uk |www.fhug.org.uk