RE: [LegacyUG] Searching on a couple's given names

2008-03-17 Thread ronald ferguson
.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 SQ

Re: [LegacyUG] Searching on a couple's given names

2008-03-16 Thread Ron Taylor
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 (((tblM

Re: [LegacyUG] Searching on a couple's given names

2008-03-12 Thread Mary Young
Use GenViewer Lite: download free from http://www.mudcreeksoftware.com/ Mary Young www.cmy.org.uk Free on-line backups at https://mozy.com/?ref=QV6646 Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergr

Re: [LegacyUG] Searching on a couple's given names

2008-03-11 Thread Lill Ann Parry
Why not use the marriage list and change the options to sort by given name. Then use either the male or female name to find them. I would use whichever name I have the least of in my database. Lill Ann Richard Yardley wrote: Please can someone help me? How would I search for an individual w

Re: [LegacyUG] Searching on a couple's given names

2008-03-11 Thread JLB
You could try sorting the Marriage List by first names on the wife's side or the husbands and see if you have less Johns or less Marys and then scan the list. The one you're looking for might stand out. JL JLog - simple computer technology for genealogists http://www3.telus.net/Jgen/jlog.html

[LegacyUG] Searching on a couple's given names

2008-03-11 Thread Richard Yardley
Please can someone help me? How would I search for an individual with the given name of John who was married to someone called Mary? It sounds such a simple query but I can't for the life of me, find the answer. Thank you, Richard No virus found in this outgoing message. Checked by AVG. Versi