You could do it in one memo using ICASE(), then macro expand the memo.
>Ok, but if there are more than one possible condition, then I would have to have the same number of memo fields to handle the different possible values, right? For example, if there could be 3 possible conditions, then I would need three memo fields, one for each condition.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer