Memo and Character Fields

[RSeidman]

Is it possible to place both a memo and a character field in a calculated "IIF" field.____Where l_name is a character field, and Memo1 is a memo field, is there any way to have the following calculated field.____IIF(sales_id=^01^, l_name, memo1)____I thank you in advance for your guidance.____RHS

[kfleming]

Unfortunately in an IIF() both return values have to be the same data type. So two memo fields or two character fields would work but you cannot have one of each.____Kathleen__R&R Support