Family Historian User Group

Is there a report somewhere that lists just the surnames in a family tree?

Sue

ID:4366

Not that I can think of, you can obviously use a query to list all the surnames, but you would need to copy them to a file to remove the duplicates.

Thank you for the reply Jane. What should I type in as a query for this information please.

Sue

Sue,
You could create a new custom query with the following Column definition:

Heading: Name(SURNAME) [or anything else you like]
Expression: %INDI.NAME[1]:SURNAME%
Sort: Ascending

You would also need to delete the column headed 'Individual' which appears by default for an Individual query.

You may want to include on the query Rows tab a filter such as the following to exclude blank surnames:

Condition: Exclude if...
Expression: =IsTrue(%INDI.NAME:GIVEN_ALL% = %INDI.NAME%)
Operator: is true

A new function in v4.1.0 provides a neater method to eliminate blank surnames from a query if desired:

Condition: Exclude if...
Expression: =FieldText(%INDI%,'INDI.NAME:SURNAME')
Operator: is null