* Problems with a Free BMD query

[susanpenter]

I have been trying to set up a simple query as follows:

Add if %INDI.BIRT[1].DATE% was later than 1837
Exclude if %INDI.BIRT[1].DATE% was later than 1915
Add if %INDI.BIRT[1].SOUR[1]>% is null

So in theory anyone born after 1837 but before 1915 without a source for their birth should show however when run individuals from as late as 1969 birth are being brought up.

Does anyone have a clue why this may not be working?

Thanks

[TimTreeby]

It is because your last line is adding everyone who has No source for their birth, irrespective of when they where born.
If you change the last line to say Exclude if not null then should do what you want. have just played and can't do Exclude if not Null for sources so try changing the order. Thus

Add if %INDI.BIRT[1].SOUR[1]>% is null
Exclude if %INDI.BIRT[1].DATE% was earlier than 1837
Exclude if %INDI.BIRT[1].DATE% was later than 1915

[Jenny143]

Try using exclude unless birth date was less than 1915 rather than exclude if.
Jenny

[tatewise]

On the assumption you will be wanting to check other Events such as Marriage and Death using FreeBMD, then I would advise using a Fact Query rather than an Individual Query.

Start from the Standard Query for All Facts and Save as Custom Query with your chosen name.

The Row filters would then be:
Add if =FactLabel(%FACT%) matches Birth
Exclude unless %FACT.SOUR[1]>% is null
Exclude if %FACT.DATE% was earlier than 1837
Exclude if %FACT.DATE% was later than 1915

You might also want to add:
Exclude if %FACT.DATE% is null

Then by simply changing the first filter to Marriage or Death, etc, you can report on any Fact.
You could even make the Value a Parameter and choose when running the Plugin.

The real hidden benefit is for Family Facts such as Marriage, which are tricky with an Individual Query when there are multiple Marriages.