If
{@CalculateYears} = [3,4] then "Opal",
If
{@CalculateYears} = [5,6,7,8,9] then "Topaz",
If
{@CalculateYears} = [10,11,12,13,14] then "Pearl",
If
{@CalculateYears} = [15,16,17,18,19] then "Ruby",
If
{@CalculateYears} = [20,21,22,23,24] then "Emerald",
If
{@CalculateYears} = [25,26,27,28,29] then "Diamond",
If
{@CalculateYears} > 30 then "Pewter"
I'm so confused. I'm just trying to create a special Anniversary report. If the individual has been here ofr 3 or 4 years, then he gets an "Opal" catalog, and so on. Help please?!
IP Logged
