If you want to calculate any dates that Legacy does not offer, and you know your way around in Access, You can use the following code. Paste this into the Query SQL code window in a copy of your database. You would open Access, then open the fdb file. Open a new query in design mode, then choose SQL view and paste the code. Go back to the Query view, and modify the query as you wish.
You can substitute any other dates you want to calculate, just by changing field names in the query window. I hope this helps. SELECT [HusbGivenName] & " " & [HusbSurname] AS Husband, Left([MarSD],4)-Left([HusbBirthSD],4) AS [Wife Age at Marriage], [WifeGivenName] & " " & [WifeSurname] AS Wife, Left([MarSD],4)-Left([WifeBirthSD],4) AS [Husband Age at Marriage] FROM tblMR RIGHT JOIN tblIR ON tblMR.IDIRHusb = tblIR.IDIR WHERE (((tblIR.IDIR)>1) AND ((tblMR.HusbBirthSD)>1) AND ((tblMR.WifeBirthSD)>1) AND ((tblMR.MarSD)>1)) ORDER BY tblIR.IDIR; Mike McCabe 480.510.4944 [EMAIL PROTECTED] http://michaeljmccabe.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Deb Inman Sent: Saturday, August 09, 2003 4:07 AM To: [EMAIL PROTECTED] Subject: [LegacyUG] Age of Mother at Birth of Child? Wish List idea Gary: I too would like this ability, but it doesn't appear as if the age report will do this. Another comment about the age report: One half of my inheritance is French-Canadian. The majority of birth dates are actually baptism dates, so my birth field is empty. I do wish the age report calculated from baptism date. Is it possible to change fields in the age report? Deb --- Gary Bartlett <[EMAIL PROTECTED]> wrote: > Is there any way to generate a report or list of all individuals > showing the age of their mother (or father) at the time of their > birth (optionally > sorted by her/his age at their birth)? If not from > within Legacy, then > perhaps in Access? > > Thanks, > Gary > > > Legacy User Group Etiquette guidelines can be found > at: > http://www.LegacyFamilyTree.com/Etiquette.asp > > To find past messages, please go to our searchable > archives at: > http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/ > > To unsubscribe please visit: > http://www.legacyfamilytree.com/LegacyLists.asp Legacy User Group Etiquette guidelines can be found at: http://www.LegacyFamilyTree.com/Etiquette.asp To find past messages, please go to our searchable archives at: http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/ To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp Legacy User Group Etiquette guidelines can be found at: http://www.LegacyFamilyTree.com/Etiquette.asp To find past messages, please go to our searchable archives at: http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/ To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp
