[AccessD] Blank line after concat

[Kostas Konstantinidis]

Hi Stuart,
I have already tried both "&" and "+" 


-----Original Message-----
From: AccessD <accessd-bounces at databaseadvisors.com> On Behalf Of Stuart
McLachlan
Sent: Sunday, August 12, 2018 12:38 PM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Blank line after concat

Get rid of the + and just use &.  Those two operators work differently with
Nulls.

? "A" & Null  & "B"
returns "AB"

? "A" + Null + "B"
returns Null


On 12 Aug 2018 at 11:49, Kostas Konstantinidis 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