>>ALLTRIM is used to often and on meaningless places. In fact, the statement
>>

>>..
>> IIF(EMPTY(Sourcetable.fieldC), "No LIsting Provided", Sourcetable.fieldC);
>>..
>>

>>would do, except Field_C is Varchar. Even then, most likely TRIM() will be enough.
>
>Too verbose. I'd prefer
>

>... evl(Sourcetable.fieldC, "No LIsting Provided")...
>

Thank you for reminding me, I had forgotten about evl().