[AccessD] Blank line after concat

Kostas Konstantinidis kost36 at gmail.com
Sun Aug 12 04:21:16 CDT 2018


Thank's Paul 
But now it leaves a blank line at the top of the field and the concat
doesn't work while there is not Chr(13)+Chr(10) between Tel and e-mail

The result is
BLANK LINE
Tel: +4369917273854e-mail: jpz at gmx.at


-----Original Message-----
From: AccessD <accessd-bounces at databaseadvisors.com> On Behalf Of Paul
Hartland via AccessD
Sent: Sunday, August 12, 2018 12:00 PM
To: Access List <accessd at databaseadvisors.com>
Cc: Paul Hartland <paul.hartland at googlemail.com>
Subject: Re: [AccessD] Blank line after concat

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
>
--
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