Then in your query, add the table and GROUP BY the
expression:
CallDtl: IIf(IsOther, "Other", [CallDetail])

I followed your instructions and I get an error that reads:

“The expression you entered has an invalid . (dot) or ! operator or invalid
parentheses. You may have entered an invalid identifier or typed parentheses
following the Null constant”

--
Message posted via http://www.accessmonster.com