* Is there a plugin/query to report Addresses

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile. If your question fits in one of these subject-specific sub-forums, please ask it there.
Post Reply
avatar
wigansaint
Diamond
Posts: 58
Joined: 24 Nov 2013 19:48
Family Historian: V7
Location: Appley Bridge,Wigan

Is there a plugin/query to report Addresses

Post by wigansaint » 02 Feb 2015 22:18

which will show the addresses where individuals lived during their lifetime, or can the same result be achieved by a report in FH?

Thanks for any reply.

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

Re: Is there a plugin/query to report Addresses

Post by tatewise » 02 Feb 2015 22:50

I have moved this to General Usage because that could be achieved with a custom Query.

Start with View > Standard Queries > All Facts.
You will see it lists Facts with Dates, Owners, and Places.
If you click on the Fact Owner 1 column heading, it brings all the Facts for each person together.
With a little customisation the Address details can be added and sorted as necessary.

So in the Query Menu top right choose Save As Custom Query and give it a suitable Query Name.
Select the Columns tab so we can customise what to list.

Select the Heading Fact Owner 1 and click up arrow until it is at the top.
At the bottom select Sort: Ascending and click Update button on right.

Select the Heading Fact Owner 2 and click up arrow until it is 2nd from top.

Select the Heading Fact date and at bottom select Sort: Ascending and click Update button.

Now in the Fields on left select Address and click > button in the middle.
Select that Heading Address and click up arrow until it is above Place.

Finally click the red triangular Run Query button towards top right.
That should give a Result Set close to what you want.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

Post Reply