Page 1 of 1
Query on Address fields
Posted: 06 Sep 2016 11:13
by RogerF
Sorry if this is another senior moment. Is it possible to write a query which reports on the number of uses of each distinct entry in all Address fields? Something like:
Code: Select all
Apple Avenue 3
Back Street 37
Corporation Road 10
...
Re: Query on Address fields
Posted: 06 Sep 2016 11:20
by Jane
Re: Query on Address fields
Posted: 06 Sep 2016 12:31
by RogerF
Thank you Jane, and of course Peter.
Re: Query on Address fields
Posted: 06 Sep 2016 13:24
by tatewise
Those counts are actually built into FH via the Tools > Work with Data > Addresses dialogue and the associated Special Data Report.
Re: Query on Address fields
Posted: 07 Sep 2016 05:09
by StevieSteve
The thing about the Work with Data reports (at least in V5) is that they include the facts for everyone in the database whereas I'd like to be able to restrict them to just related or Pool 1 individuals.
It'll be MyFirstPlugin when I get the time
Re: Query on Address fields
Posted: 07 Sep 2016 08:20
by tatewise
In the meantime Stevie, use File > Import/Export > Export > GEDCOM File and Select the desired Individuals via Add using Query. After the exported Gedcom is saved in Public folder, FH will offer to open it, and then the Work with Data details will apply to that selection of Individuals. Create whatever Custom Queries you need to Select the desired Individuals.
Re: Query on Address fields
Posted: 07 Sep 2016 17:36
by RogerF
Thank you, Mike,
I just can't believe I missed the Tools > Work with Data > Addresses option. Creeping senility, eh?...
Re: Query on Address fields
Posted: 09 Sep 2016 06:18
by StevieSteve
In the meantime Stevie, use ...
Thanks for that workround, Mike, it'll be very useful