Re: [LegacyUG] Search for marriages

[Brenda Anderson]

Just a caveat on this.  If a person happens to be married twice, and the 
first marriage is before 1934 and the second one  is after 1933, this 
person will show up in the search results, even if they had NO marriage 
in 1933.  The program search is comparing all marriages for a person 
against the search criteria.

So, you'll get all your 1933 marriages by searching for 'after 31 dec 
1932' and 'before 1 jan 1934'  but you might get some extra ones too.

Alternatively, if you have Access or another program that can query your 
database, you can run this query:

SELECT  `IDMR`, `HusbGivenName`, `HusbSurname`, `WifeGivenName`, 
`WifeSurname`, `MarSD` FROM `tblMR` `tblMR` WHERE ( ( `MarSD` BETWEEN 
19330101 AND 19331231 ) )

Hope this helps,
Brenda
NZ
Mark Lang wrote:
Click Search icon on toolbar
Click Detailed Search tab
In Primary Condition:
Look for whom - Marriage
Where to look - Marr.Event-Date
How to Look - After
What to look for - 31 Dec 1932
Check Second Condition; check AND
Look for whom - Marriage
Where to look - Marr.Event-Date
How to Look - Before
What to look for - 31 Dec 1934
Click Create List. All marriages for the year 1933 will be listed in the
Search Results.
Mark
 

-----Original Message-----
From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On 
Behalf Of A West
Sent: Friday, 1 October 2004 6:18 PM
To: [EMAIL PROTECTED]
Subject: [LegacyUG] Search for marriages

Using Legacy Deluxe 5.0, how can I find all the
marriages that occurred in the year 1933?
   


 


--
Brenda Anderson
  ~   ~   ~   ~   ~
www.curiouskiwi.com
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