Recent content by rramkrishna

  1. R

    Seperation of Numbers and Text from alphanumeric string

    Thanks Paul, the query worked and got the output desired. Thanks again for your help.
  2. R

    Seperation of Numbers and Text from alphanumeric string

    sorry query is val([tabl1]![col1])
  3. R

    Seperation of Numbers and Text from alphanumeric string

    its a update query to col1 data to col2 val([tabl1]!col1) all my data in the above format in column 1 I would like to update in column 2 1st part of numbers
  4. R

    Seperation of Numbers and Text from alphanumeric string

    I am sorry, the function is available, however when I used the same in a query the result is showing as 0
  5. R

    Seperation of Numbers and Text from alphanumeric string

    Yes I had checked, this function doesn't thre at MS-Access.
  6. R

    Seperation of Numbers and Text from alphanumeric string

    Hi, Can any one hlp me MS-Access VBA code to seperate numbers and string from an alphanumeric string. Example: Source: 598790abcdef2T Output Required: 598790 Source: 5789065432abcdefghijklT Output Required: 5789065432 Please help, I am using MS Access 2007 Thanks Ram
See more
Back
Top Bottom