* 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
Post Reply
avatar
quarlton
Famous
Posts: 136
Joined: 26 Feb 2004 13:07
Family Historian: V7
Location: Lincolnshire
Contact:

Extending FACTOWNER in query

Post by quarlton » 15 May 2022 14:35

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: 24386
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Extending FACTOWNER in query

Post by tatewise » 15 May 2022 17:34

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: 136
Joined: 26 Feb 2004 13:07
Family Historian: V7
Location: Lincolnshire
Contact:

Re: Extending FACTOWNER in query

Post by quarlton » 15 May 2022 19:05

So near, and yet so far 😀

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

Post Reply