[AccessD] add a number in between

Stuart McLachlan stuart at lexacorp.com.pg
Thu Apr 14 17:03:15 CDT 2005


On 14 Apr 2005 at 21:38, Pedro Janssen wrote:

> 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.
> 
IIf (Instr(fieldA)> 0,....previous function...,fieldA & "." & fieldB)

> 
> ----- 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
> >
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

-- 
Stuart





More information about the AccessD mailing list