Is it possible to include details such as birth dates in a fact query.
I can select and display individuals attached to a fact but I can not include individual data in the report.
Does anyone know how to do this?
ID:5887
* Individual details in fact query
-
Jane
- Site Admin
- Posts: 8440
- Joined: 01 Nov 2002 15:00
- Family Historian: V7
- Location: Somerset, England
- Contact:
Individual details in fact query
Yes, but you need to use the =GetField() function, so for example
=GetField(FactOwner(%FACT%,1,MALES_FIRST),"%INDI.BIRT[1].DATE%")
will give you the Birth date of the first fact owner.
=GetField(FactOwner(%FACT%,1,MALES_FIRST),"%INDI.BIRT[1].DATE%")
will give you the Birth date of the first fact owner.
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
-
tatewise
- Megastar
- Posts: 27078
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Individual details in fact query
In the Fact Query simply add Columns such as:
Heading Expression
Owner =GetRecord(%FACT%)
Fact %FACT%
Date %FACT.DATE%
Place %FACT.PLAC%
Then on the Rows tab add a Filter such as:
Condition: Add if
Expression: =FactLabel(%FACT%)
Operator: matches
Value: Birth
Tick the Parameter option and enter a Label: such as Fact Name
Heading Expression
Owner =GetRecord(%FACT%)
Fact %FACT%
Date %FACT.DATE%
Place %FACT.PLAC%
Then on the Rows tab add a Filter such as:
Condition: Add if
Expression: =FactLabel(%FACT%)
Operator: matches
Value: Birth
Tick the Parameter option and enter a Label: such as Fact Name
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
Individual details in fact query
Thank you Jane. That is exactly what I was looking for.