[AccessD] add a number in between

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


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





More information about the AccessD mailing list