As dedicated genealogists, most of us strive to locate every available census record for the people in our family trees. While I’ve made a strong effort to do just that, I know I still have individuals who are missing census records. Those missing records aren’t just gaps in documentation—they may be the very clues I need to connect DNA matches to a common ancestor.
With that in mind, I wanted to identify individuals in my RootsMagic database who were alive in 1950 but do not have a 1950 census record. In my database, I attach census records using a Residence fact dated to the census year, so my goal was to find people who were living in 1950 yet lacked a Residence fact dated 1950.
Thankfully, RootsMagic’s Group feature allows users to write rules to identify exactly this kind of research problem. Unfortunately, getting the logic right took a bit of trial and error.
Wrestling with Group Logic
My first instinct was to look for people without a 1950 Residence fact. That led me to try the following rule combinations:
- Fact Type: Residence
Date: Contains 1950
Fact Exists: Is False
→ Returned ZERO people - Fact Type: Residence
Date: Contains 1950
Fact Exists: Is True
→ Returned 755 people - Fact Type: Residence
Date: Does Not Contain 1950
Fact Exists: Is False
→ Returned 18,244 people
Logically, the first option seemed like it should work—it should have identified people missing a 1950 Residence fact. Instead, it was the third option, with its double negative, that actually produced the results I needed.
Narrowing the Group to Those Alive in 1950
Once I understood how RootsMagic was interpreting the Residence fact logic, I added another rule to eliminate individuals who had died before the 1950 census.
The working rules became:
- Fact Type: Residence (include shared facts)
Date: Does not contain 1950
Fact Exists: Is False
AND
- Fact Type: Death (do not include shared facts)
Date: Is after 31 Dec 1949
This refined group identified 2,417 people who were alive in 1950 but missing a 1950 Residence fact.
Focusing on a Specific Line
Since I’m currently working on my RALSTON line, I took this one step further by using my color-coding system to isolate those descendants.
I added a third rule:
- Color: Is Green — Set 4
Combined with the previous rules, this resulted in 227 individuals who:
- Were alive in 1950
- Are color-coded as RALSTON descendants
- Lack a 1950 Residence (census) fact
Turning a Group into a Research Plan
Now comes the satisfying part—doing the genealogy. With this targeted group in hand, I can systematically search for missing 1950 census records, fill in those gaps, and—hopefully—uncover the evidence needed to connect DNA matches to documented ancestors.
This exercise was a good reminder that while RootsMagic groups are powerful, they sometimes require thinking like the software, not just like a genealogist. Once the logic clicks, though, the results can be incredibly useful.