Hi Guys - putting it all together, with a minor tweak for the values returned, and we have a winner:
IIF (CLN_Bad_Debt = 0 , '' , 'Bad Debt') as Bad_Debt
Many, many thanks!
NOW:
Any thoughts on CLN_Client_Title_id which represents the salutation as:
1 = Mr
2 = Mrs
3 = Miss etc.!
I'm...