Scott Marcus
marcus at tsstech.com
Fri Apr 15 10:36:00 CDT 2005
Shouldn't that be... IIf (Instr(fieldA," ")> 0,....previous function...,fieldA & "." & fieldB) In-stead-of... IIf (Instr(fieldA)> 0,....previous function...,fieldA & "." & fieldB) Scott Marcus TSS Technologies, Inc. marcus at tsstech.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Thursday, April 14, 2005 6:03 PM To: Access Developers discussion and problemsolving Subject: Re: [AccessD] add a number in between 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com NOTICE: This electronic mail transmission is for the use of the named individual or entity to which it is directed and may contain information that is privileged or confidential. If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of any information contained herein is prohibited. If you have received this electronic mail transmission in error, delete it from your system without copying or forwarding it, and notify the sender of the error by replying via email or calling by TSS Technologies at (513) 772-7000, so that our address record can be corrected. Any information included in this email is provided on an “as is” and “where is” basis, and TSS Technologies makes no representations or warranties of any kind with respect to the completeness or accuracy of the information contained in this email, or with respect to any other matters communicated in this email. TSS Technologies hereby disclaims any and all express or implied warranties of any kind. Nothing in this email shall be construed to create any kind of contractual or binding agreement or commitment by or on behalf of TSS Technologies, Inc. and the recipient, or any third-parties.