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?
* Extending FACTOWNER in query
-
- Famous
- Posts: 166
- Joined: 26 Feb 2004 13:07
- Family Historian: V7
- Location: Lincolnshire
- Contact:
Extending FACTOWNER in query
Dave Simpson ~ Boulton, Braham, Carney, Simpson and Jacobs
- tatewise
- Megastar
- Posts: 28410
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Extending FACTOWNER in query
Remove the % characters in your final attempt similar to earlier attempts.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
-
- Famous
- Posts: 166
- Joined: 26 Feb 2004 13:07
- Family Historian: V7
- Location: Lincolnshire
- Contact:
Re: Extending FACTOWNER in query
So near, and yet so far
Many thanks Mike
Many thanks Mike
Dave Simpson ~ Boulton, Braham, Carney, Simpson and Jacobs