I have a custom query that gives me the surnames of everyone in my file.
However, needless to say there are many rows in the result set that are identical is there any way to 'group by' in the query so that I only have one row per surname? I have been doing this in Excel up till now but it would be easier to do this in FH.
* Surname query
- Jane
- Site Admin
- Posts: 8514
- Joined: 01 Nov 2002 15:00
- Family Historian: V7
- Location: Somerset, England
- Contact:
Re: Surname query
Surname Summary Report from Plugin Store.
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."
- Valkrider
- Megastar
- Posts: 1570
- Joined: 04 Jun 2012 19:03
- Family Historian: V7
- Location: Lincolnshire
- Contact:
Re: Surname query
Thanks very much @Jane I was doing trying to do something similar to this with a query.
- Jane
- Site Admin
- Posts: 8514
- Joined: 01 Nov 2002 15:00
- Family Historian: V7
- Location: Somerset, England
- Contact:
Re: Surname query
Queries by their nature always have one record per line (or one per fact for fact Queries), you need to use Plugin result sets if you want to combine multiple records.
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."
- Valkrider
- Megastar
- Posts: 1570
- Joined: 04 Jun 2012 19:03
- Family Historian: V7
- Location: Lincolnshire
- Contact:
Re: Surname query
I was hoping there was something like 'group by' which is standard in SQL queries.