List of marriages

philjo · Post by **philjo** » 02 Feb 2005 08:53

I am trying to write a query that will give me a chronological list of marriages so that I can ake the list to the records office & check the newspaper reports of the time

I have created a Family type query.

I selected family as spouse - mar.plac and mar.date (both sorted), and also husband and wife names.

this gives me a nice list of all marriages, sorted first by place then by date.

I tried to put a filter on the place/date fields so that I could restrict the output to specific places/date ranges, but despite the box coming up asking me to enter the place, it ignored this when the query ran.

I tried both 'add if...' and 'exclude unless..' on the filters - it didn't make any difference.

Can anyone offer any suggestions as to how to get this to work ?

Also, if anyone knows how to put another filter on it to restrict it to marriages of people related to a specific person, then I can also limit the list to one side of the family only.

Many thanks,

Jeremy

ID:768

YouTube · Post by **Jane** » 02 Feb 2005 08:57

If you upload the query you have already done to a post (just click on the upload image/file and once uploaded click on the insert link)

I will look to see if I can spot the problem. I suspect you may need to use add if followed by exclude unless.

philjo · Post by **philjo** » 03 Feb 2005 08:49

Jane,

Thanks for that. I tried again last night and got it to work - you were correct - I needed to use an excude unless statement.

I have now got the query to list chronologically all marriages for descendents for a specific person, which you select when the query runs.

However, it seems to omit second marriages for men. It did include second marriages for women, though.

I tried to get the file to upload for you to look at, but I cannot find the file on my PC.

It is not in the family historian/queries/custom directory, and have searched the c: drive for all fhq files, but cannot find it.

In FH it appears on the list of custom queries.

Jeremy

YouTube · Post by **Jane** » 03 Feb 2005 09:25

The query will be in
Documents and Settings/Application Data/Calico Pie etc if you are on Windows 2000 or XP

philjo · Post by **philjo** » 04 Feb 2005 08:54

Jane,

Thank you for that - I have now uploaded the query.

It seems to run OK, but misses some second marriages.

the selection at the start prompts for the date range. It also asks for entry of ther person from which the people in the output are decended from.

http://www.fhug.org.uk/images/uploads/M ... ndents.fhq

Jeremy

YouTube · Post by **Jane** » 04 Feb 2005 09:02

You are actually only checking for First Marriages.

I suspect you need to build a family query rather than an indivdual one.

If I get a chance at the weekend I will try out a few things.

Post by **SimonOrde** » 11 Feb 2005 10:53

Jeremy

Queries always return at most one row for each record that matches the filtering used. An Individual query will return one row for each matching Individual. So you won't get one row for each marriage with an Individual query.

I would suggest instead that you add extra columns for 2nd and 3rd marriages (more if nec), and change the filtering to add people whose LAST marriage falls after the start date. To do this change the first filter line to:

Add if %INDI.FAMS[MARR.DATE% was later than ['Start Date']

The operator will probably switch to 'was on' when you make this change. If so, set it back to 'was later than'.

In the columns list, the columns should be changed to look something like this (with the expression in brackets):

Individual (INDI)
Spouse 1 {INDI.~SPOU>)
Sp1 Marr Date (INDI.FAMS>MARR.DATE)
Sp1 Marr Place (INDI.FAMS>MARR.PLAC)
Spouse 2 {INDI.~SPOU[2]>)
Sp2 Marr Date (INDI.FAMS[2]>MARR.DATE)
Sp2 Marr Place (INDI.FAMS[2]>MARR.PLAC)
Spouse 3 {INDI.~SPOU[3]>)
Sp3 Marr Date (INDI.FAMS[3]>MARR.DATE)
Sp3 Marr Place (INDI.FAMS[3]>MARR.PLAC)

Notice that you use the shortcut for the spouse name.

You would only be able to sort meaningfully on one marriage, of course, which is a slight negative.

Incidentally this assumes that each person's marriages are in chronological order. Use 'Re-order out-of-sequence data' on the Tools menu to make sure that they are, if in doubt.

philjo · Post by **philjo** » 11 Feb 2005 12:50

Simon,

Thank you for this - I will try it out over the weekend.

Jeremy

Family Historian User Group