Thanks for all the replies.  Been years since I have done SQL but I might give it a try.  If I do i'll share. mike On Sunday, February 15, 2015 3:52 AM, "[email protected]" <[email protected]> wrote: SEND REQUESTS FOR CHANGES TO YOUR MAILINGS TO: [email protected] NOT TO THE MAIL LIST. ------------------------------- To unsubscribe from the list, please send an email to [email protected] with the word 'unsubscribe' without the quotes in the subject and the body of the message Today's Topics:   1. Re: Time taking for emails to arrive (Michael Reich)   2. Like a list of "years married" (Michael Fike)   3. Re: Like a list of "years married" (Sue Maxwell)   4. Re: Like a list of "years married" (Tom Holden)   5. Re: Like a list of "years married" (Sue Maxwell) ---------------------------------------------------------------------- Message: 1 Date: Sat, 14 Feb 2015 10:05:35 -0600 From: Michael Reich <[email protected]> Subject: Re: [RMagic] Time taking for emails to arrive To: James Payne <[email protected]>,     [email protected] Message-ID: <[email protected]> Content-Type: text/plain; charset=us-ascii Not happening to me. ----------------------------- Researching Surnames Elk, Goldstein, Kasin (Kisensky), Philipson, Reich, Sax, Schwartz, Ureen, Wershub (Warshup) ----------------------------- Michael Reich 1916 Deere Lane Glendale Heights, IL 60139 [email protected] blog: www.mike-reich.blogspot.com > On Feb 13, 2015, at 10:03 PM, James Payne via <[email protected]> wrote: > > I am not certain why this is happening, but today I received 100 emails from this list dated the last day in January to today and this seems to be quite ordinary. > I would be interested to know if it's just me (I have a new computer, not a year old yet, or if it happens to other people on this list > > Jim > > > > > > =================================== > RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ > http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS > WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ > > > ------------------------------- > To unsubscribe from the list, please send an email to [email protected] with the word 'unsubscribe' without the quotes in the subject and the body of the message ------------------------------ Message: 2 Date: Sat, 14 Feb 2015 23:22:16 +0000 (UTC) From: Michael Fike <[email protected]> Subject: [RMagic] Like a list of "years married" To: "[email protected]" <[email protected]> Message-ID:     <[email protected]> Content-Type: text/plain; charset=UTF-8 I tried searching the archives so as not to duplicate this question ... but I did not find it. I'm new to RM and I would like to create a report showing how long a couple was married. Nothing fancy. ?Once someone puts me down the right path I should be able to go from there. Thanks for the assistance. mike ------------------------------ Message: 3 Date: Sat, 14 Feb 2015 17:19:34 -0700 From: Sue Maxwell <[email protected]> Subject: Re: [RMagic] Like a list of "years married" To: Michael Fike <[email protected]>,     "[email protected]" <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain;    charset=us-ascii There is a marriage report but it does not do any calculation of married time. You can use the calculator to subtract dates but only for one person at a time. I can't even think of a possible custom report that would give you what you want. You could create a custom report containing marriage dates and divorce dates (and/or death dates). Then export the data to Excel and do the calculation there. Sue > On Feb 14, 2015, at 4:22 PM, Michael Fike via <[email protected]> wrote: > > I tried searching the archives so as not to duplicate this question ... but I did not find it. > I'm new to RM and I would like to create a report showing how long a couple was married. > Nothing fancy.  Once someone puts me down the right path I should be able to go from there. > Thanks for the assistance. > mike > > > =================================== > RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ > http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS > WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ > > > ------------------------------- > To unsubscribe from the list, please send an email to [email protected] with the word 'unsubscribe' without the quotes in the subject and the body of the message ------------------------------ Message: 4 Date: Sat, 14 Feb 2015 22:31:43 -0500 From: Tom Holden <[email protected]> Subject: Re: [RMagic] Like a list of "years married" To: Sue Maxwell <[email protected]>,     "[email protected]" <[email protected]> Cc: Michael Fike <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain;    charset=us-ascii However, for a person with multiple marriages, I don't think RootsMagic reports are smart enough to output the corresponding divorce or death dates on the same line as the marriage date for a given couple. It may output them in the order the facts were entered and thus mix up on the same line facts from two couples. I suspect the only way to do this reliably is an export to some software that does give that report or to develop a custom SQLite query of the RootsMagic database. Tom > On Feb 14, 2015, at 7:19 PM, Sue Maxwell via <[email protected]> wrote: > > There is a marriage report but it does not do any calculation of married time. You can use the calculator to subtract dates but only for one person at a time. > > I can't even think of a possible custom report that would give you what you want. > > You could create a custom report containing marriage dates and divorce dates (and/or death dates). Then export the data to Excel and do the calculation there. > > Sue > > >> On Feb 14, 2015, at 4:22 PM, Michael Fike via <[email protected]> wrote: >> >> I tried searching the archives so as not to duplicate this question ... but I did not find it. >> I'm new to RM and I would like to create a report showing how long a couple was married. >> Nothing fancy.  Once someone puts me down the right path I should be able to go from there. >> Thanks for the assistance. >> mike >> >> >> =================================== >> RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ >> http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS >> WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ >> >> >> ------------------------------- >> To unsubscribe from the list, please send an email to [email protected] with the word 'unsubscribe' without the quotes in the subject and the body of the message > > > > =================================== > RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ > http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS > WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ > > > ------------------------------- > To unsubscribe from the list, please send an email to [email protected] with the word 'unsubscribe' without the quotes in the subject and the body of the message ------------------------------ Message: 5 Date: Sat, 14 Feb 2015 21:44:56 -0700 From: Sue Maxwell <[email protected]> Subject: Re: [RMagic] Like a list of "years married" To: Tom Holden <[email protected]> Cc: "[email protected]" <[email protected]>,     Michael Fike <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain;    charset=utf-8 You are right on Tom. It's not a great idea, but at least a possibility. In RM there is no built in way to calculate the combination of dates to relationships. Knowing you, you probably could do it with SQLite. ? Sue > On Feb 14, 2015, at 8:31 PM, Tom Holden <[email protected]> wrote: > > However, for a person with multiple marriages, I don't think RootsMagic reports are smart enough to output the corresponding divorce or death dates on the same line as the marriage date for a given couple. It may output them in the order the facts were entered and thus mix up on the same line facts from two couples. > > I suspect the only way to do this reliably is an export to some software that does give that report or to develop a custom SQLite query of the RootsMagic database. > > Tom > >> On Feb 14, 2015, at 7:19 PM, Sue Maxwell via <[email protected]> wrote: >> >> There is a marriage report but it does not do any calculation of married time. You can use the calculator to subtract dates but only for one person at a time. >> >> I can't even think of a possible custom report that would give you what you want. >> >> You could create a custom report containing marriage dates and divorce dates (and/or death dates). Then export the data to Excel and do the calculation there. >> >> Sue >> >> >>> On Feb 14, 2015, at 4:22 PM, Michael Fike via <[email protected]> wrote: >>> >>> I tried searching the archives so as not to duplicate this question ... but I did not find it. >>> I'm new to RM and I would like to create a report showing how long a couple was married. >>> Nothing fancy.  Once someone puts me down the right path I should be able to go from there. >>> Thanks for the assistance. >>> mike >>> >>> >>> =================================== >>> RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ >>> http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS >>> WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ >>> >>> >>> ------------------------------- >>> To unsubscribe from the list, please send an email to [email protected] with the word 'unsubscribe' without the quotes in the subject and the body of the message >> >> >> >> =================================== >> RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ >> http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS >> WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ >> >> >> ------------------------------- >> To unsubscribe from the list, please send an email to [email protected] with the word 'unsubscribe' without the quotes in the subject and the body of the message ------------------------------ To contact the ROOTSMAGIC-USERS list administrator, send an email to [email protected] To post a message to the ROOTSMAGIC-USERS mailing list, send an email to [email protected] __________________________________________________________ To unsubscribe from the list, please send an email to [email protected] with the word "unsubscribe" without the quotes in the subject and the body of the email with no additional text. End of ROOTSMAGIC-USERS Digest, Vol 10, Issue 65 ************************************************