You're welcome.

>More life saving!!!!!!!!
>
>Thanks again
>Jim
>
>
>>There's no IIF() function in SQL Server. You would use CASE function instead.

...
>>CASE dbo.Made2ManageReport_v.antitip
>>WHEN 'R' THEN 'RIGHT'
>>WHEN 'L' THEN 'LEFT'
>>WHEN 'B' THEN 'BOTH'
>>ELSE 'NONE' END  AS AntiTip,
>>...