Query List of married women by married name

jsphillips · Post by **jsphillips** » 27 Nov 2011 18:29

1. The Query that is 'List of married Women by married name' does not pick up second and third marriages.
How can it be altered to show these please ??
2. Additionally it does not show women with children whos male spouse is not named??
The file family statistics of mine show 384 but the list of marriages only show 348.
Is it possible to have a query that can show the the 384 family datas??
Thanks for any help

ID:5599

Post by **tatewise** » 27 Nov 2011 20:06

1. List of married Women by married name with 1st, 2nd & 3rd marriages.
You need to add details for not just the [1]st but also the [2]nd and [3]rd Spouse/Family as follows.
On the Columns tab:
Edit the Spouse.Name(SURNAME) %INDI.~SPOU[1]>NAME[1]:SURNAME% entry to
become Spouse2.Name(SURNAME) %INDI.~SPOU[2]>NAME[1]:SURNAME% and click Add button.
Edit the Family as Spouse.Marriage.Date %INDI.FAMS[1]>MARR[1].DATE% entry to
become Family2 as Spouse.Marriage.Date %INDI.FAMS[2]>MARR[1].DATE% and click Add button.
What you are doing is changing the Spouse/Family index from [1] to [2].
Similarly Add columns for index [3].
On the Rows tab
Add the following filter and move it up to the first Row:
Add if =Not((%INDI.~SPOU[1]>NAME:SURNAME% = '') and (%INDI.~SPOU[2]>NAME:SURNAME% = '') and (%INDI.~SPOU[3]>NAME:SURNAME% = '')) is true
Delete the filter Exclude if INDI.~SPOU>NAME:SURNAME is null

2. Show the all the Family data.
The easiest solution is to create a New Custom Query with Query Type = Family.
On the Columns tab use the Fields pane to add whatever data you want, then Run Query.

jsphillips · Post by **jsphillips** » 28 Nov 2011 08:33

Extremely grateful I have tried for an hour to do what you suggested but it will not even let me ' add' in some circumstances.
Extremely frustrated.
Is it unfair of me to ask you to create it and add it to the custom queries please ??

Post by **tatewise** » 28 Nov 2011 10:10

Have added Downloads > Queries > Married Women Names.
Also in Knowledge Base under FHUG Downloads for Name Details of People there is Query:Individual ~ Married Women Names at:
http://www.fhug.org.uk/wiki/doku.php?id ... ried_women

jsphillips · Post by **jsphillips** » 28 Nov 2011 10:49

Thanks VERY MUCH
Much appreciated

Family Historian User Group