I have a report with ages of employees and dependants. How would I correctly write a conditional formula:
If dependant age ({@DepAge}) is greater than 26 and dependant relationship ({tbl.ClDependant.Relationship}) is not "SPOU" then FirstName, MiddleInit, LastName, Relationship, BirhtDate, Age and Gender are Bold and Red.
If {@DepAge) > 26 and {tbl.ClDependent.Relationship} <> "SPOU" then
{tbl.ClDependant.FirstName} and
{tbl.ClDependant.MiddleInit} and
{tbl.ClDependant.LastName} and
{tbl.ClDependant.Relationship} and
{tbl.ClDependant.BirhtDate} and
{@DepAge} and
{tbl.ClDepenant.Gender}
???? this is as far as I get. Nor do I know where I should really put this formula.
Thank you for all your help!
If dependant age ({@DepAge}) is greater than 26 and dependant relationship ({tbl.ClDependant.Relationship}) is not "SPOU" then FirstName, MiddleInit, LastName, Relationship, BirhtDate, Age and Gender are Bold and Red.
If {@DepAge) > 26 and {tbl.ClDependent.Relationship} <> "SPOU" then
{tbl.ClDependant.FirstName} and
{tbl.ClDependant.MiddleInit} and
{tbl.ClDependant.LastName} and
{tbl.ClDependant.Relationship} and
{tbl.ClDependant.BirhtDate} and
{@DepAge} and
{tbl.ClDepenant.Gender}
???? this is as far as I get. Nor do I know where I should really put this formula.
Thank you for all your help!