* Custom Expression Question for Query
Custom Expression Question for Query
I am trying to build a custom query that returns all people of a certain surname. What expression would I use?
-
LornaCraig
- Megastar
- Posts: 2996
- Joined: 11 Jan 2005 17:36
- Family Historian: V7
- Location: Oxfordshire, UK
Re: Custom Expression Question for Query
Conditon: Add If
Expression: %INDI.NAME[1]:SURNAME%
Operator: matches
Expression: %INDI.NAME[1]:SURNAME%
Operator: matches
Lorna
-
tatewise
- Megastar
- Posts: 27088
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Custom Expression Question for Query
BTW:
You can get a similar list in the Records Window on the Individuals tab by using the Filter: for Last Name top left.
Depending on the Options chosen that list can include the Married Surname of women, and Alternate Surnames.
To include all those via a Query would require many extra Row tab filter expressions.
Lorna's expression is valid but only checks the Primary Surname of each Individual.
You can get a similar list in the Records Window on the Individuals tab by using the Filter: for Last Name top left.
Depending on the Options chosen that list can include the Married Surname of women, and Alternate Surnames.
To include all those via a Query would require many extra Row tab filter expressions.
Lorna's expression is valid but only checks the Primary Surname of each Individual.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry