[AccessD] Blank line after concat

Paul Hartland paul.hartland at googlemail.com
Sun Aug 12 04:26:26 CDT 2018


Sorry that was just a quick example, try moving the chr commands to before
all the fields etc, if I get near a laptop today will send an example but I
doubt it, it was really just to give you an idea

Paul

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

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