[AccessD] add a number in between

A.D.Tejpal adtp at touchtelindia.net
Wed Apr 13 23:37:42 CDT 2005


Pedro,

    Select query given below should get you the desired results. A and B are the names of two fields in table named T_Nums. C is the name of calculated field generated by the query, inserting the contents of B into A in the manner specified by you.

Best wishes,
A.D.Tejpal
--------------

==================================
SELECT A, B, Replace(A," ","." & B & " ") AS C
FROM T_Nums;
==================================

  ----- Original Message ----- 
  From: Pedro Janssen 
  To: AccessD at databaseadvisors.com 
  Sent: Thursday, April 14, 2005 00:23
  Subject: [AccessD] add a number in between


  Hello groep,

  i have a field that containes codes like:

  6.10.3.3 0
  5.04.2.4 #0
  6.12.3.3 #1
  4.07.1.1 1

  i need to add a value (.x, after the last number, before the space.

  an example:

  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

  Can this been done?

  Pedro Janssen     



More information about the AccessD mailing list