[AccessD] Blank line after concat

Kostas Konstantinidis kost36 at gmail.com
Sun Aug 12 03:49:43 CDT 2018


Dear people,
In a query I use 

ID_DIR: (IIf(IsNull([International Title]);[original title];[International
Title])+Chr(13)+Chr(10)) & (IIf(IsNull([director]);"";("Directed by: " &
[director])+Chr(13)+Chr(10))) & (IIf(IsNull([DIR_TEL]);"";"Tel:
"+([DIR_TEL]) + Chr(13)+Chr(10))) & (IIf(IsNull([DIR_MAIL]);"";("e-mail: " &
[DIR_MAIL])))

The problem is that if any of [Director], [DIR_TEL[ or [DIR_MAIL] fields are
null it always returns a blank line to the end

Could you please help?

Thank's
/kostas



More information about the AccessD mailing list