Surname Only List

sstoneman · Post by **sstoneman** » 22 Feb 2010 13:35

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

Sue

ID:4366

YouTube · Post by **Jane** » 22 Feb 2010 13:51

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.

sstoneman · Post by **sstoneman** » 22 Feb 2010 15:51

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

Sue

PeterR · Post by **PeterR** » 22 Feb 2010 16:42

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

PeterR · Post by **PeterR** » 20 Mar 2010 14:56

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

Family Historian User Group