* how can I define a query to extract a burial list
how can I define a query to extract a burial list
I have many individuals assigned to a variety of burial grounds and I want to extract a list for one or more Cemeteries, thus when I visit the ground I have a list of "my" relatives.
- tatewise
- Megastar
- Posts: 28410
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: how can I define a query to extract a burial list
Welcome to the FHUG.
I will assume you use the standard Burial Event to record burial details and put the name of the cemetery burial ground in the Address field of those events.
So create an Individual Query with a Rows tab filter such as:
Add if %INDI.BURI.ADDR% contains ["Cemetery"]
The ["Cemetery"] is a prompt to enter the cemetery burial ground name.
It is created by ticking the Parameter option lower right, and entering Cemetery as the Label.
See how_to:creating_a_query|> Creating a Query and its Rows Tab advice for more details.
You may have more questions if you are unfamiliar with creating Queries.
I will assume you use the standard Burial Event to record burial details and put the name of the cemetery burial ground in the Address field of those events.
So create an Individual Query with a Rows tab filter such as:
Add if %INDI.BURI.ADDR% contains ["Cemetery"]
The ["Cemetery"] is a prompt to enter the cemetery burial ground name.
It is created by ticking the Parameter option lower right, and entering Cemetery as the Label.
See how_to:creating_a_query|> Creating a Query and its Rows Tab advice for more details.
You may have more questions if you are unfamiliar with creating Queries.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
Re: how can I define a query to extract a burial list
A word of warning, if like me, you are not always careful how exactly you enter the cemetery name, you will first need to ensure that you have been consistent in naming your burial grounds. Use Tools/Work with data/Addresses to check .
A quick check of mine, and I found the odd cementery, and cemetary, neither of which will be listed if you are looking for cemetery
A quick check of mine, and I found the odd cementery, and cemetary, neither of which will be listed if you are looking for cemetery
Mike Loney
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
Re: how can I define a query to extract a burial list
Thank you for the outstanding and well articulated reply.
It just might be the convincing argument for me to complete my assessment of the software and actually become a "paid up" subscriber. I do appreciate your time and effort in answering my query.
Darryl Wise
It just might be the convincing argument for me to complete my assessment of the software and actually become a "paid up" subscriber. I do appreciate your time and effort in answering my query.
Darryl Wise
-
- Famous
- Posts: 193
- Joined: 04 Nov 2015 17:32
- Family Historian: V7
- Location: Worcestershire, UK
Re: how can I define a query to extract a burial list
That brought to mind visions of mobsters sending rivals to 'sleep with the fishes' in 'concrete overshoes'...Gowermick wrote:... I found the odd cementery...
Peter Collier
Collier, Savory, Buckerfield, Edmonds, Low, Dungey, Lester, Chambers, Walshe, Moylan, Bradley, Connors, Udale, Wilson, Benfield, Downey
Collier, Savory, Buckerfield, Edmonds, Low, Dungey, Lester, Chambers, Walshe, Moylan, Bradley, Connors, Udale, Wilson, Benfield, Downey
Re: how can I define a query to extract a burial list
Pete,
Very punny
Very punny
Mike Loney
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com