Ron I'm afraid that your SQL codings do not work in OpenOffice Base as it does not use Access SQL but HSQL. I haven't really got time to look at this one today but will transcribe it shortly.
Ron Ferguson _____________________________________________________________________ For Genealogy, Software and Social visit: http://www.fergys.co.uk New Blog: Open Legacy Family File with Open Office View the Grimshaw Family Tree at: http://www.fergys.co.uk/Grimshaw/ For The Fergusons of N.W. England See: http://myweb.tiscali.co.uk/fergys/ _____________________________________________________________________ ________________________________ From: [EMAIL PROTECTED] To: LegacyUserGroup@legacyfamilytree.com Subject: Re: [LegacyUG] Searching on a couple's given names Date: Sun, 16 Mar 2008 19:52:31 -0600 Using MS Access or Open Office, you can utilize the following SQL query to find marriages given any portion of the husband and/or wife names. SELECT tblMR.IDMR, tblMR.IDIRHusb, tblMR.HusbSurname, tblMR.HusbGivenName, tblMR.IDIRWife, tblMR.WifeSurname, tblMR.WifeGivenName FROM tblMR WHERE (((tblMR.IDIRHusb)<>0) AND ((tblMR.IDIRWife)<>0) AND ((tblMR.HusbSurname) Like "*" & [Enter any part of Husband Surname: ] & "*") AND ((tblMR.HusbGivenName) Like "*" & [Enter any part of Husband Given Name: ] & "*") AND ((tblMR.WifeSurname) Like "*" & [Enter any part of Wife Surname: ] & "*") AND ((tblMR.WifeGivenName) Like "*" & [Enter any part of Wife Given Name: ] & "*")) ORDER BY tblMR.IDMR; Hope this helps. Perhaps such a query will be included in v7 as it is quite simple and could easily be augmented with tagging. Ron Taylor _________________________________________________________________ Get Messenger on your mobile, text MSN to 63463 now! http://mobile.uk.msn.com/pc/messenger.aspx Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
