[AccessD] add a number in between

Hello A.d. Teypal and Stuart,

thanks to you both for helping me out.
Again you saved me time.

Just out of interest, i solved this in another way,
but i have also codes in the same field like: 5.11.3.3 
How could i adjust the expression so that it can handle 
both types of codes at ones.

Pedro



----- Original Message -----
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problemsolving"
<accessd at databaseadvisors.com>
Sent: Thursday, April 14, 2005 10:17 AM
Subject: Re: [AccessD] add a number in between


> On 13 Apr 2005 at 20:53, Pedro Janssen wrote:
>
> > fieldA                     fieldB
> > 6.10.3.3 0             16
> > 5.04.2.4 #0           8
> > as result i would like:
> > fieldC
> > 6.10.3.3.16 0
> > 5.04.2.4.8 #0
> >
>
> This should do it:
> fieldC: Left$(fieldA,Instr(fieldA," ") -1) & "." & fieldB &
> Mid$(fieldA,Instr(fieldA," "))
>
>
>
>
>
>
>
> --
> Stuart
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>