Family Historian User Group

Can somebody please tell me what I am doing wrong here, I am trying to edit a Factowner name expression to display Surname first with the following expression.

=Field(FactOwner(%FACT%,1,MALES_FIRST),'INDI.NAME:SURNAME_FIRST')

I have added :SURNAME_FIRST to an existing expression, the Query editor is accepting it as a valid expression, but running the query still returns Given Names Surname.

Ideally I would like the surname in capitals, but getting it to display first would be an achievement.

Check out FHUG Knowledge Base An Overview of Queries and near the end under Sorting a Fact Query on Owner Surname there are all the answers.

There is an important distinction between the =Field(...) and =FieldText(...) functions.