[AccessD] Blank line after concat

Paul Hartland paul.hartland at googlemail.com
Sun Aug 12 03:59:44 CDT 2018


You could try moving the chr statements

(IIf(IsNull([DIR_TEL]);""; Chr(13)+Chr(10)+ "Tel:
"+([DIR_TEL]))) & (IIf(IsNull([DIR_MAIL]);"";("e-mail: " &
[DIR_MAIL])))



On Sun, 12 Aug 2018, 09:50 Kostas Konstantinidis, <kost36 at gmail.com> wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list