* Extending FACTOWNER in query

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile. If your question fits in one of these subject-specific sub-forums, please ask it there.
Post Reply
avatar
quarlton
Famous
Posts: 166
Joined: 26 Feb 2004 13:07
Family Historian: V7
Location: Lincolnshire
Contact:

Extending FACTOWNER in query

Post by quarlton »

I'm trying to find all people who:

Had an event in the USA
Straight forward - Fact query Exclude unless %FACT.PLAC>% ends with USA

Twist in the tail is that I need to identify only those whose surname was Yoxall at any point.
No problem for those born as Yoxall:

Just filter query by =FieldText(FactOwner(%FACT%,1,MALES_FIRST),'INDI.NAME:SURNAME') contains Yoxall
I searched the forum and found the root part of this entry thanks to Jane and Mike

However I need a way to check if a person, male or female, had a spouse called Yoxall.
Can't seem to be able to pick it up using the Fact query

I tried along the lines =FieldText(FactOwner(%FACT%,1,MALES_FIRST),'%INDI.~SPOU[1]>NAME[1]:SURNAME%')


I feel that there should be a way of coming at it from the Individual
Something like Include if the Individual had any FACT.PLAC> in the USA

Any suggestions?
Dave Simpson ~ Boulton, Braham, Carney, Simpson and Jacobs
User avatar
tatewise
Megastar
Posts: 28341
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Extending FACTOWNER in query

Post by tatewise »

Remove the % characters in your final attempt similar to earlier attempts.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
avatar
quarlton
Famous
Posts: 166
Joined: 26 Feb 2004 13:07
Family Historian: V7
Location: Lincolnshire
Contact:

Re: Extending FACTOWNER in query

Post by quarlton »

So near, and yet so far 😀

Many thanks Mike
Dave Simpson ~ Boulton, Braham, Carney, Simpson and Jacobs
Post Reply