10 replies to this topic

[vlanders]

When looking at cemetery transcripts, etc., I will do a search of my database to see if any names match. But, I have my women entered by their maiden names, and the women on the lists usually have only their married name listed.

Any suggestion on how to search, create a custom report, or otherwise obtain a list of women on my database by married name?

Thanks!

[Candy]

What I usually do in those circumstances, is put in the married name, and then scan them to see the spouses listed in the lower right box. If I find one that matches, or is a possible variation/nickname, I will copy the obit and do further checking at a later time. To me, it is easier to copy it and toss it if it is not family than to try and remember where I found it the first time.

[Alfred]

You can do a report or search > Find for selected people, selecting by data fields.
Given name -- contains -- Mary
AND -- surname (birth or Married) - equals -- Smith
AND -- surname == does not equal -- Smith

To find or list all people who have Mary as part of their given name who married a Smith.


======== ------------------ ==============

After noticing the two following notes, I thought of a problem with my "Solution"

Smith is quite a common name, it is possible that Mr. Smith might marry Miss Smith and then the "And surname == does not equal == Smith" would eliminate this kind of union.

[vlanders]

Thank you both for your replies. A solution to my problem, and quickly, too! Gotta love this message board.

[Jim Belanger]

That's what I do. Search for given name contains AND surname equals AND married surname equals.
With those three criteria, I can generally narrow the field considerably. Then, I look at the spouse's name to see if it's a match for each of the choices.

[Ludlow Bay]

You can do a report or search > Find for selected people, selecting by data fields.
Given name -- contains -- Mary
AND -- surname (birth or Married) - equals -- Smith
AND -- surname == does not equal -- Smith

To find or list all people who have Mary as part of their given name who married a Smith.

Wouldn't one save a step by using

"given name" "contains"
AND
"married surname" "equals" ?

Or would that give different results?

[Alfred]

"Wouldn't one save a step by using
"given name" "contains"
AND
"married surname" "equals" ?
"=============================

It sure would!

I just looked in the search cryteria for "Surname" and saw "Surname" and "Surname (married or birth)", I didn't look under married for "Married Surname."

And, since I cannot Remember everything, I had forgotten that it was even one of the choices.

This "Married surname" thingie even takes care of the potential problem with a Smith marrying another Smith that I just added to my previous post.

[Ludlow Bay]

It sure would!

I just looked in the search cryteria for "Surname" and saw "Surname" and "Surname (married or birth)", I didn't look under married for "Married Surname."

And, since I cannot Remember everything, I had forgotten that it was even one of the choices.

This "Married surname" thingie even takes care of the potential problem with a Smith marrying another Smith that I just added to my previous post.

That criteria entry should be relabeled as "Surname (married)" instead of "Married surname" to bring it in line with the other entries.

[Jim Belanger]

Wouldn't one save a step by using

"given name" "contains"
AND
"married surname" "equals" ?

Or would that give different results?

Saves a step but adds a lot of "hits". If you look for Surname AND married SURNAME it sure narrows the search a lot more.

[Ludlow Bay]

Saves a step but adds a lot of "hits". If you look for Surname AND married SURNAME it sure narrows the search a lot more.

True, perhaps, but not appropriate to this thread. The initial problem was to "search, create a custom report, or otherwise obtain a list of women on my database by married name". The person was using "cemetery transcripts ... [where] ... the women on the lists usually have only their married name listed." In other words, a case where the UNmarried surname is not known.

[Jim Belanger]

OK, so I lost track of the original question. My wife says I do that a lot! Anyway, use my suggestion when it fits. I guess I offered "too much" help! Have a nice weekend everyone!