I am trying to create a custom report to list all the women in my database who were born in France and married in Canada between 1662 and 1674 and NOT married in Acadian. I am choosing by data fields: Marriage date is after 1662 and Marriage date is before 1674 and Birth place contains france and Any Fact place does not contain Acadia And I am still getting people who were born in Acadia. Why? Apparently, I am not entering my search criteria right, but I don't know how to change it. What I would really like is list of women only, so I added and Sex is female But I still get marriage info from Acadia Thanks Margie in Washington State

The Any Fact criteria contributes to your unwanted result - all it takes is for the person who satisfies the first three criteria to have any fact not containing Acadia to be included. Your third criteria satisfies your fourth so you should get everyone born in France who married between 1662 and 1674 anywhere. I am surprised that you get people born in Acadia unless the Place is actually "Acadia, New France". Maybe you meant to type "married", not "born", as that is logical. What you describe as your goal would be satisfied by changing your fourth criterion to And Marriage Place does not contain Acadia. That will work reliably provided a person has one and only one Marriage event and likewise one Birth event so that the criteria for a Fact Type apply simultaneously to the same event. Otherwise one event can satisfy one criterion while another event of the same type can satisfy another. Tom On Wednesday, 4 May 2016, M. A. Beldin via <rootsmagic-users@rootsweb.com> wrote: > I am trying to create a custom report to list all the women in my database > who were born in France and married in Canada between 1662 and 1674 and NOT > married in Acadian. > > I am choosing by data fields: > > Marriage date is after 1662 > and Marriage date is before 1674 > and Birth place contains france > and Any Fact place does not contain Acadia > > And I am still getting people who were born in Acadia. > > Why? > > Apparently, I am not entering my search criteria right, but I don't know > how to change it. > > What I would really like is list of women only, so I added > > and Sex is female > > But I still get marriage info from Acadia > > Thanks > Margie in Washington State > > > =================================== > RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ > http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS > WISH LIST: http://www.rootsmagic.com/forums/ BLOG: > http://blog.rootsmagic.com/ > > > ------------------------------- > To unsubscribe from the list, please send an email to > ROOTSMAGIC-USERS-request@rootsweb.com <javascript:;> with the word > 'unsubscribe' without the quotes in the subject and the body of the message >

Thanks, Tom, I almost have it refined. You hit the nail on the head with the Acadia, New France. that is exactly how I had entered that place name, so I was contradicting myself by wanting France but not Acadia. Here's my next effort: *Marriage date is after 1662* *and Marriage date is before 1674* *and Birth place contains france* *and Sex is female* *and Marriage place does not contain acadia, new france* I still had one person who was born in acadia, so I added: *and Birth place does not contain acadia, new france* And so far, it looks like it worked! thanks for your help, Margie in Washington state On Wed, May 4, 2016 at 12:12 PM, Tom Holden <ve3meo@gmail.com> wrote: > The Any Fact criteria contributes to your unwanted result - all it takes > is for the person who satisfies the first three criteria to have any fact > not containing Acadia to be included. Your third criteria satisfies your > fourth so you should get everyone born in France who married between 1662 > and 1674 anywhere. I am surprised that you get people born in Acadia unless > the Place is actually "Acadia, New France". Maybe you meant to type > "married", not "born", as that is logical. What you describe as your goal > would be satisfied by changing your fourth criterion to > And Marriage Place does not contain Acadia. > That will work reliably provided a person has one and only one Marriage > event and likewise one Birth event so that the criteria for a Fact > Type apply simultaneously to the same event. Otherwise one event can > satisfy one criterion while another event of the same type can satisfy > another. > > Tom > > > On Wednesday, 4 May 2016, M. A. Beldin via <rootsmagic-users@rootsweb.com> > wrote: > >> I am trying to create a custom report to list all the women in my database >> who were born in France and married in Canada between 1662 and 1674 and >> NOT >> married in Acadian. >> >> I am choosing by data fields: >> >> Marriage date is after 1662 >> and Marriage date is before 1674 >> and Birth place contains france >> and Any Fact place does not contain Acadia >> >> And I am still getting people who were born in Acadia. >> >> Why? >> >> Apparently, I am not entering my search criteria right, but I don't know >> how to change it. >> >> What I would really like is list of women only, so I added >> >> and Sex is female >> >> But I still get marriage info from Acadia >> >> Thanks >> Margie in Washington State >> >> >> =================================== >> RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ >> http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS >> WISH LIST: http://www.rootsmagic.com/forums/ BLOG: >> http://blog.rootsmagic.com/ >> >> >> ------------------------------- >> To unsubscribe from the list, please send an email to >> ROOTSMAGIC-USERS-request@rootsweb.com with the word 'unsubscribe' >> without the quotes in the subject and the body of the message >> >