When one selects more than one address from the list of addresses, the 'Where Used' button is greyed out. Is there a query to overcome this? If not, can anyone point me in the right direction?
I'm looking to try to produce a 'timeline' of, say, a particular street so I can see who lived where in what year, etc. I have lots of instances where boy married girl next door, etc., and think this would make an extremely good narrative...I have all my addresses including the house number, etc., so selecting all addresses from the same street at the moment is beyond me.
* Multiple Address report
- SpencerDudeUK
- Diamond
- Posts: 91
- Joined: 01 Jun 2018 15:07
- Family Historian: V7
- tatewise
- Megastar
- Posts: 27088
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Multiple Address report
See fhugdownloads:contents:query_all_facts_filter_by_date_label_or_text|> Query:Fact ~ All Facts Filter by Date, Label, or Text.
Take the All Facts Filter by Text and use cog Query Menu > Save As Custom Query with name All Facts Filter by Address.
Then Update its Rows filter so the Expression is:
=ContainsText(%FACT.ADDR%,["Find Address"],STD)
If the Find Address is a street or road name then all matching Facts will be listed with their Owner and in Date order.
Take the All Facts Filter by Text and use cog Query Menu > Save As Custom Query with name All Facts Filter by Address.
Then Update its Rows filter so the Expression is:
=ContainsText(%FACT.ADDR%,["Find Address"],STD)
If the Find Address is a street or road name then all matching Facts will be listed with their Owner and in Date order.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
- SpencerDudeUK
- Diamond
- Posts: 91
- Joined: 01 Jun 2018 15:07
- Family Historian: V7
Re: Multiple Address report
Superb! Works well - thanks very much for the tip.