Results 1 to 2 of 2
  1. 08-04-2009, 10:45 AM #1
    tmcrouse
    tmcrouse is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Apr 2009
    Posts
    169

    Query Help

    I have a table that has templatename and the column I need to trim looks as follows:

    ABC123
    ADDINF123
    BATCH123


    BILL123
    COB123
    HPHC123
    MEDCRH123

    What I need is just the alpha and to get rid of the numbers that follow. I have tried all sorts of trims but the right returns the 123. The left doesn't work since the alphas are varying lengths.
    Reply With Quote Reply With Quote
  2. 08-04-2009, 11:05 AM #2
    tmcrouse
    tmcrouse is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Apr 2009
    Posts
    169

    update

    Right now I am just doing an update query to do

    update to ABC and the criteria as *ABC* so it takes off the trailing numbers.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums