* How to create a list of places

Older V4 Queries please post for any version in the General Forum
Locked
avatar
jmpjack
Platinum
Posts: 37
Joined: 13 Jun 2009 23:22
Family Historian: None

How to create a list of places

Post by jmpjack » 07 Jan 2012 01:20

I am planning to visit Devon in the next couple of months to do a bit of FH research mainly around graveyards and villages. Can someone tell me if there is a way of extracting information as a printed list from my V4 FH to tell me which people were living where and when in the various villages I plan to travel through?.

For example, is it possible to create a specific village query or even a general 'Devon' query, bearing in mind my FH covers a large proportion of the country now, or is there some other way of doing this that I am missing?

As I won't be able to take my full family tree with me, and I am going with my sister who is not fully acquainted with it but enthusiastic, I want to make sure I am looking for the right people in the right places!

Any help gratefully recieved
Thanks
Jackie

ID:5772

avatar
RSellens
Famous
Posts: 172
Joined: 07 Aug 2005 17:25
Family Historian: V6.2

How to create a list of places

Post by RSellens » 07 Jan 2012 08:04

Hi Jackie,
It should be fairly easy to do a query to find people born/married/died in a particular place. However, i am not sure if you can easily do a catch all query to find people living in a place, as you can have multiple 'events' for residence. I assume you know how to create a query, so all you need to do is select the columns you want to display, and then the 'place' attributes for each event you want to check if it occured in Devon (i.e. Birth, Baptism, Christing, etc). Then on the 'rows' tab, just add the conditions, using the 'Add if' condition for each place, where it contains 'Devon'. When you run the query you should get a list of people for whom one of the events occured in devon.

Anothe option that may be slightly better for you is to use 'Named Lists'. What you could do is use the 'Tools->Work with Data->Places' menu option. This give you a list of all the places in your file, you can then select a place and click the 'records' button to see all the people/families that contain that place. From the list of people/families, you can add then to a named list, and you could create a list for each town/village, and then use the different lists to print seperate reports for each place you want to vist, that way you get a list by place rather than a list of people.

Richard

User avatar
Jane
Site Admin
Posts: 8442
Joined: 01 Nov 2002 15:00
Family Historian: V7
Location: Somerset, England
Contact:

How to create a list of places

Post by Jane » 07 Jan 2012 10:16

A quick and dirty way to do this is to use the Contains Text standard query and search for the placename.
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."

User avatar
tatewise
Megastar
Posts: 27088
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

How to create a list of places

Post by tatewise » 07 Jan 2012 10:17

I suggest you would find it easier to start with a Query Type of Fact rather than Individual.
This avoids the problem of multiple Residence/Census/Marriage/etc Facts.

On the General tab select Query Type: Fact.

On the Columns tab create columns for:
Owner  -  =GetRecord(%FACT%)
Fact   -  %FACT%
Date   -  %FACT.DATE%
Place  -  %FACT.PLAC%
Note   -  %FACT.NOTE2%
etc...

On the Rows tab the filter would be:
Add if %FACT.PLAC% contains 'Devon'.


From the Query Menu you can Save Query Result Set As > PDF File and print that PDF.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
jmpjack
Platinum
Posts: 37
Joined: 13 Jun 2009 23:22
Family Historian: None

How to create a list of places

Post by jmpjack » 09 Jan 2012 15:43

Thank you everyone for your replies, I will have a tinker around and see which one comes up with the easiest result

Many thanks again
Jackie[smile]

Locked