Family Historian User Group

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?

Remove the % characters in your final attempt similar to earlier attempts.

So near, and yet so far

Many thanks Mike