Conditional fields in queries
Posted: 13 Mar 2004 09:48
Is it possible to make the value returned in a column conditional?
e.g.
If INDI.FAMS[1]>MARR[1].DATE:YEAR NAME[1]:SURNAME
else
''
The aim here is to only show the spouse's surname if the marriage date was before 1861.
Useful when researching the census.
Have you ever noticed that no matter how good the software, we still want more [smile]
ID:336
e.g.
If INDI.FAMS[1]>MARR[1].DATE:YEAR NAME[1]:SURNAME
else
''
The aim here is to only show the spouse's surname if the marriage date was before 1861.
Useful when researching the census.
Have you ever noticed that no matter how good the software, we still want more [smile]
ID:336