As a newcomer I wonder if it is possible to create a list of the surnames in a family tree.
I would like to have a simple list which has one line entry for each different surname in the total list of individuals.
Help appreciated.
David
ID:2383
* Family Names Query
-
SimonOrde
- Program Designer
- Posts: 352
- Joined: 18 Nov 2002 10:20
- Family Historian: V7
- Location: Calico Pie
Family Names Query
It's easy enough to create a query that will show a list of surnames in your family tree file. But there's no way that you can get it to only show each surname once.
To create a surname list, create a new Individual query in the Query Window. In the Fields list, expand 'Name' and select :SURNAME. Click '>' to add it. Select Name(SURNAME) and change the heading to just 'Surname' and the Sort to 'Ascending' and click Update. You might want to add filters to remove NULL names and empty surnames, too.
When you run the query it will show a list of surnames. If you select all the cells and copy them into another program, you may be able to get rid of the duplication that way.
To create a surname list, create a new Individual query in the Query Window. In the Fields list, expand 'Name' and select :SURNAME. Click '>' to add it. Select Name(SURNAME) and change the heading to just 'Surname' and the Sort to 'Ascending' and click Update. You might want to add filters to remove NULL names and empty surnames, too.
When you run the query it will show a list of surnames. If you select all the cells and copy them into another program, you may be able to get rid of the duplication that way.
Family Names Query
Thanks for ypur help. Maybe this is possible in the future as a wishlist item?
David
David
-
Jane
- Site Admin
- Posts: 8442
- Joined: 01 Nov 2002 15:00
- Family Historian: V7
- Location: Somerset, England
- Contact:
Family Names Query
It's already there
http://www.fhug.org.uk/wishlist/wldispl ... lwlref=209
http://www.fhug.org.uk/wishlist/wldispl ... lwlref=209