Query to search on multiple names

rfj1001 · Post by **rfj1001** » 31 May 2011 16:10

I want to search my FH database to find people that match a particular first name and surname.

My problem is that some of the people in my dataset have up to eight variant first names spellings and twelve variant surname spellings.

Any thoughts on how I might approach this?

Thanks

ID:5119

YouTube · Post by **Jane** » 31 May 2011 16:42

Searching either for the Surname or the First Names are pretty easy, but combining them would probably mean using a pretty complex function statement.

I'll have a play, but I suspect that's the way to go.

rfj1001 · Post by **rfj1001** » 01 Jun 2011 11:58

Thanks Jane - the best I could get was to set up a query on the surnames and create a gedcom file from that; then set up another query on that gedcom file that worked on first names. I just ended up with too many gedcom files

PeterR · Post by **PeterR** » 01 Jun 2011 13:13

I guess you could (1) run your surname query and use the Query Menu option to Add Result Set Records to Named List.... Then you could (2) run the forename query on your original GEDCOM file with an additional filter to Exclude unless... the records are in the 'surname' List populated in step 1 above.

Family Historian User Group