Hello,
I want to make a query
The first part is :
Columns:
Rows
Result
and this is OK.
Now i want to add in this query from a date to a date, for instance (1-1-1820) to (1-1-1880).
How can i do this?
Greetings
Koen
* Date query
- tatewise
- Megastar
- Posts: 28414
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Date query
Hi Koen,
Firstly, your existing Rows tab filters seem a bit unusual to me.
Add unless %INDI.BIRT.PLAC>% is null will add everyone whose Birth event has a Place regardless of Date.
Add unless %INDI.BIRT.DATE% is null will add everyone whose Birth event has a Date regardless of Place.
There will be many rows with both a Birth Place and a Birth Date.
But you will have some rows with a Birth Place but no Birth Date and others with a Birth Date but no Birth Place.
i.e. The filter is saying add everyone who has either a Birth Place or a Birth Date.
Is that what you wanted?
My guess is that you wanted everyone with both a Birth Place and a Birth Date and that needs:
Exclude if %INDI.BIRT.PLAC>% is null
Exclude if %INDI.BIRT.DATE% is null
I apologise if my guess is mistaken.
To further constrain the Date, use the was earlier than and was later than Operators and add these two Rows:
Exclude if %INDI.BIRT.DATE% was earlier than 1 Jan 1820
Exclude if %INDI.BIRT.DATE% was later than 1 Jan 1880
Firstly, your existing Rows tab filters seem a bit unusual to me.
Add unless %INDI.BIRT.PLAC>% is null will add everyone whose Birth event has a Place regardless of Date.
Add unless %INDI.BIRT.DATE% is null will add everyone whose Birth event has a Date regardless of Place.
There will be many rows with both a Birth Place and a Birth Date.
But you will have some rows with a Birth Place but no Birth Date and others with a Birth Date but no Birth Place.
i.e. The filter is saying add everyone who has either a Birth Place or a Birth Date.
Is that what you wanted?
My guess is that you wanted everyone with both a Birth Place and a Birth Date and that needs:
Exclude if %INDI.BIRT.PLAC>% is null
Exclude if %INDI.BIRT.DATE% is null
I apologise if my guess is mistaken.
To further constrain the Date, use the was earlier than and was later than Operators and add these two Rows:
Exclude if %INDI.BIRT.DATE% was earlier than 1 Jan 1820
Exclude if %INDI.BIRT.DATE% was later than 1 Jan 1880
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
Re: Date query
Tatewise,
I change it a little bit with the parameter option and it's great!!.
Thanks for helping me.
Greetings
Koen
I change it a little bit with the parameter option and it's great!!.
Thanks for helping me.
Greetings
Koen