Results 1 to 3 of 3
  1. #1
    m2boost is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2019
    Location
    Hickory, NC
    Posts
    7

    Truncate data

    How can I truncate a data stream like the one value?



    total cutting time: 151.2s §MES,1015
    total cutting time: 90.2s §MES,1015

    I want to extract the seconds value, like I want to see:

    151.2
    90.2

    Thanks for the help in advance!

  2. #2
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    2,193
    Create a query based on the table with your data and add a calculated field with the following expression:

    Result: Left([YourFieldName],InStr(1,[YourFieldName],"s")-1)

    Replace "YourFieldName" with the name of your field.
    If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
    Not everyone can access an accdb, you may reach a broader audience by attaching in mdb format.

    Bob Fitzpatrick

    I have never failed. I have found a thousand ways that do not work!

    Microsoft Community Contributor Award (2011)



  3. #3
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    2,193
    I see that you have asked this same question again in another thread.

    Will you be starting any more threads, with the same question, that we can waste our time with?
    If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
    Not everyone can access an accdb, you may reach a broader audience by attaching in mdb format.

    Bob Fitzpatrick

    I have never failed. I have found a thousand ways that do not work!

    Microsoft Community Contributor Award (2011)



Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 15
    Last Post: 11-05-2019, 07:31 PM
  2. Truncate Table
    By jo15765 in forum Modules
    Replies: 4
    Last Post: 02-23-2017, 04:18 AM
  3. Truncate data
    By DCV0204 in forum Queries
    Replies: 6
    Last Post: 07-03-2012, 07:43 AM
  4. Truncate text
    By jgelpi in forum Programming
    Replies: 3
    Last Post: 07-16-2009, 12:44 PM
  5. truncate (?) values
    By ridgeview80 in forum Access
    Replies: 3
    Last Post: 06-02-2009, 02:19 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums