>>.. >> IIF(EMPTY(Sourcetable.fieldC), "No LIsting Provided", Sourcetable.fieldC); >>.. >>>>would do, except Field_C is Varchar. Even then, most likely TRIM() will be enough.
>... evl(Sourcetable.fieldC, "No LIsting Provided")...
>
Thank you for reminding me, I had forgotten about evl().