[AccessD] add a number in between

Pedro Janssen pedro at plex.nl
Mon Apr 18 13:23:19 CDT 2005


Hello Stuart and Scott,

thanks for the help.
The sql does what i need.

Pedro



----- Original Message -----
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problemsolving"
<accessd at databaseadvisors.com>
Sent: Saturday, April 16, 2005 1:09 AM
Subject: RE: [AccessD] add a number in between


> On 15 Apr 2005 at 11:36, Scott Marcus wrote:
>
> > Shouldn't that be...
> >
> > IIf (Instr(fieldA," ")> 0,....previous function...,fieldA & "." &
> > fieldB)
> >
> > In-stead-of...
> >
> > IIf (Instr(fieldA)> 0,....previous function...,fieldA & "." & fieldB)
> >
>
> Yes :-(
>
>
> --
> Stuart
>
>
> --
> 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