[AccessD] Blank line after concat

Stuart McLachlan stuart at lexacorp.com.pg
Sun Aug 12 04:38:17 CDT 2018


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
> 




More information about the AccessD mailing list