Report: Marriages This Month

         Description: Their anniversary is this month. [NOTE: Marriage Dates containing Abt., Bef., Bet., or Aft. may not have occurred this month.]


SQL: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, tng_people.branch,lastname, firstname,sex,if(sex='M',families1.marrdate,families2.marrdate),if(sex='M',families1.marrplace,families2.marrplace), tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) LEFT JOIN tng_families AS families1 ON (tng_people.gedcom = families1.gedcom AND tng_people.personID = families1.husband ) LEFT JOIN tng_families AS families2 ON (tng_people.gedcom = families2.gedcom AND tng_people.personID = families2.wife ) WHERE ((( if(sex='M',families1.marrdate,families2.marrdate) LIKE "%MAR%" )) AND ((tng_people.living !=1 && tng_people.private != 1))) AND tng_people.gedcom = "OurFamilyTree" ORDER BY lastname,firstname,if(sex='M',families1.marrdatetr,families2.marrdatetr)

Matches 1 to 50 of 228   » Comma-delimited CSV file

1 2 3 4 5 Next»

# Last Name, Given Name(s) Marriage Date Marriage Place
1 Adams, Eliza Roxana  21 Mar 1847  Markham, York, Ontario, Canada  
2 Adams, Francis Edmund  4 Mar 1897  Hannah, Cavalier, North Dakota, USA  
3 Adams, Helen Louise  16 Mar 1935  Everett, Snohomish, Washington, USA  
4 Adams, James Herman  23 Mar 1904  RM of Pembina, Manitoba, Canada  
5 Adams, John Franklin  22 Mar 1894  York, Ontario, Canada  
6 Adams, Maxine Evelyn  6 Mar 1948   
7 Adams, William John Hudson  20 Mar 1907   
8 Adams + |, Robert  28 March 1632  Great Chesterford, Essex, England  
9 Albritton, Mary Jane  3 Mar 1852  Houston, Georgia, USA  
10 Almond, Lucy Ann Frances  15 Mar 1838  Elbert, Georgia, USA  
11 Ames, David  22 Mar 1781  Groton, Middlesex, Massachusetts, USA  
12 Ames, Dorothy  8 Mar 1693/1694   
13 Anderson +, Thomas  10 Mar 1671  Bridlington, Yorkshire, England  
14 Appling, Elizabeth  5 Mar 1837  St Clair, Alabama, USA  
15 Ball +, Eleazer  23 Mar 1727  Lancaster, Worcester, Massachusetts, USA  
16 Barber +, Josiah  Bef. 12 Mar 1701/1702   
17 Barnard, Elizabeth  2 Mar 1709/10  Watertown, Middlesex, Massachusetts, USA  
18 Barnard, John  5 Mar 1682/83  Watertown, Middlesex, Massachusetts, USA  
19 Bartlett, William  Aft. 24 Mar 1817  Nicholas, Kentucky, USA  
20 Bent, Martha  10 Mar 1740  Framingham, Middlesex, Massachusetts, USA  
21 Billings, Rebecca  17 Mar 1760  Lincoln, Middlesex, Massachusetts, USA  
22 Blakey, Robert  29 Mar 1792  Bedford, Virginia, USA  
23 Bolton, Rachel  15 Mar 1838  Wilkes, Georgia, USA  
24 Booth, Lucinda Hattie  29 Mar 1900   
25 Bragg, Emma Ann  31 Mar 1911  Fulton, Georgia, USA  
26 Bragg, George Washington I  12 Mar 1892  Elbert, Georgia, USA  
27 Brayne, Anne Butler  Mar 1725  London, England  
28 Brewer, Samuel  10 Mar 1740  Framingham, Middlesex, Massachusetts, USA  
29 Brewer, Sarah Almeda  3 Mar 1844  Plymouth, Windsor, Vermont, USA  
30 Brooke, Clifford Neff Wayne  28 Mar 1855  Preble, Ohio, USA  
31 Brooke, Sarah Ann  10 Mar 1850  Preble, Ohio, USA  
32 Bullard, William  25 Mar 1866  Berrien, Georgia, USA  
33 Burnham, Ozro H.  8 Mar 1859   
34 Burns, Lizzie Mabel  15 Mar 1905  Boxborough, Middlesex, Massachusetts, USA  
35 Børrildsdatter Skaare, Anne  29 Mar 1849  Egersund, Rogaland, Norway  
36 Canary, Howard E.  16 Mar 1935  Everett, Snohomish, Washington, USA  
37 Carman, Isiah  31 Mar 1898  Marion, Illinois, USA  
38 Carman p??, John William  27 Mar 1792  Caswell, North Carolina, USA  
39 Catherwood, Joseph  23 Mar 1896  Hannah, Cavalier, North Dakota, USA  
40 Chapman, James R.  22 Mar 1836   
41 Chapman, John  1 Mar 1739   
42 Chaworth +, Maud  Bef. 2 Mar 1297  Wales  
43 Christian, Mary  13 Mar 1833  Madison, Georgia, USA  
44 Christian, Sarepta Jane  12 Mar 1892  Elbert, Georgia, USA  
45 Christian #, Jesse George I  25 Mar 1841  Elbert, Georgia, USA  
46 Clark, Sarah  1 Mar 1866  Hart, Georgia, USA  
47 Clewett, Ann  4 Mar 1818  Somerset, England  
48 Clowser, Mary  6 Mar 1841  Montgomery, Indiana, USA  
49 Cobean, Alexander  25 Mar 1892  Grey, Ontario, Canada  
50 Cobleigh, Daniel  18 Mar 1824  Littleton, Middlesex, Massachusetts, USA  


1 2 3 4 5 Next»