I have got a report 'Census Missing ages Years' and wonder if anyone could help me with it. I find it very useful but I would like it to not show any person who died before the 1841 census. This would be helpful as the report would only show the people who should appear on the censuses.
Jan
* Census Missing ages Years
- tatewise
- Megastar
- Posts: 27088
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Census Missing ages Years
Sorry Jan, but what exactly is Census Missing ages Years please?
You say it is a Report but have posted in the Plugin Discussions Forum.
So, is it a Report or a Plugin or perhaps a Query?
Is it one that you have created/customised, or have you downloaded it from somewhere?
You say it is a Report but have posted in the Plugin Discussions Forum.
So, is it a Report or a Plugin or perhaps a Query?
Is it one that you have created/customised, or have you downloaded it from somewhere?
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
Re: Census Missing ages Years
Hi, It is listed in custom queries. I thought that it was a plugin that I had downloaded.
- tatewise
- Megastar
- Posts: 27088
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Census Missing ages Years
OK, since it is a Query and not a Plugin, I've moved this posting to the FH General Usage Forum.
The nearest custom Query downloads that I can find are:
1) fhugdownloads:contents:ages_on_census|> Query:Individual ~ Ages on Census with Query name censusmissingages allyears
2) fhugdownloads:contents:census-the_missing_years-1911|> Query:Individual ~ Census - The Missing Years (Superseded) with Query name Census_Missing_Years_1911
However, both include similar Rows filter conditions:
1) Exclude if %INDI.DEAT[1].DATE:YEAR% was earlier than 1841
2) Exclude if %INDI.DEAT[1].DATE% was earlier than 1841
So, they should exclude Individuals who died before the 1841 Census.
However, that 1st one only works where an explicit simple Date of Death such as 1 Jan 1800 is recorded.
If a Date Period or Date Range such as Between 1800 and 1804 is recorded then it does NOT work!
So change the Rows filter to remove the :YEAR qualifier as in 2) above and it should work.
Those Queries were produced in 2006 and 2009, and there are more recent tools available.
The nearest custom Query downloads that I can find are:
1) fhugdownloads:contents:ages_on_census|> Query:Individual ~ Ages on Census with Query name censusmissingages allyears
2) fhugdownloads:contents:census-the_missing_years-1911|> Query:Individual ~ Census - The Missing Years (Superseded) with Query name Census_Missing_Years_1911
However, both include similar Rows filter conditions:
1) Exclude if %INDI.DEAT[1].DATE:YEAR% was earlier than 1841
2) Exclude if %INDI.DEAT[1].DATE% was earlier than 1841
So, they should exclude Individuals who died before the 1841 Census.
However, that 1st one only works where an explicit simple Date of Death such as 1 Jan 1800 is recorded.
If a Date Period or Date Range such as Between 1800 and 1804 is recorded then it does NOT work!
So change the Rows filter to remove the :YEAR qualifier as in 2) above and it should work.
Those Queries were produced in 2006 and 2009, and there are more recent tools available.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry