* Format of FactOwner
Format of FactOwner
Is there a way to format =FactOwner(%FACT%,1,MALES_FIRST) as Surname first in a query so that the query output can be sorted alphabetically by person?
-
Jane
- Site Admin
- Posts: 8442
- Joined: 01 Nov 2002 15:00
- Family Historian: V7
- Location: Somerset, England
- Contact:
Re: Format of FactOwner
You could add a column with
If you make the original column a buddy column and place it after this one you can make this column "live" for selection.
Code: Select all
=GetFieldText(FactOwner(%FACT%,1,MALES_FIRST),"%INDI.NAME:SURNAME_FIRST%")
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
-
tatewise
- Megastar
- Posts: 27089
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Format of FactOwner
Yes, see how_to:sort_fact_query_on_owner_surname|> Sort Fact Query on Owner Surname.
At the end of the Details section it provides full explanation of how to implement Jane's buddy suggestion.
At the end of the Details section it provides full explanation of how to implement Jane's buddy suggestion.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
Re: Format of FactOwner
That's perfect. Thanks a lot to both of you.