The solution in this post Individual details in fact query (6664) did not work for me in V6.
Rather than:
=GetField(FactOwner(%FACT%,1,MALES_FIRST),'%INDI.BIRT[1].DATE%')
these two entries added to the Columns section both worked a charm
Birth date:
=FieldText(FactOwner(%FACT%,1,MALES_FIRST),'INDI.BIRT.DATE')
Deathe date:
=FieldText(FactOwner(%FACT%,1,MALES_FIRST),'INDI.DEAT.DATE')
* Individual details in fact query
- tatewise
- Megastar
- Posts: 27079
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Individual details in fact query
Yes, the Expression in that posting had a syntax error (now corrected) where the single quotes (') should have been double ("), i.e.
=GetField(FactOwner(%FACT%,1,MALES_FIRST),"%INDI.BIRT[1].DATE%") which does work.
However, =GetField(...) offers special extra features as explained in the Help that are not needed here.
Even better than =FieldText(...) is =Field(...) which presents the same data but is also a clickable link that opens the Birth or Death event in the Property Box.
=GetField(FactOwner(%FACT%,1,MALES_FIRST),"%INDI.BIRT[1].DATE%") which does work.
However, =GetField(...) offers special extra features as explained in the Help that are not needed here.
Even better than =FieldText(...) is =Field(...) which presents the same data but is also a clickable link that opens the Birth or Death event in the Property Box.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
Re: Individual details in fact query
Thank you, I guessed you would know the reason why! Now even better than I imagined.