Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2012
    Posts
    2

    Question Unanswered: Help with using Functions in Access

    Hi,

    I have created a Query using Access which lists all Course Codes

    e.g ACRC01A1

    However, I want to build an expression which will remove the "A" character from between the 1 characters. (So 2nd character from the end of Course Code).

    Does anybody know how to do this and which function to use?

    Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    you coudl remoive the symbol using repalce

    eg
    SELECT my, column, list FROM mytable
    WHERE repalce(mycoursecode,"A","") = "CRC011"
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Mar 2012
    Posts
    2

    Question Access Help

    Hi,

    This is ok for one course code but I have a large number of different course codes with either A, B or C as the 2nd to last Character, of which I want to remove from all Course Codes.

    How could I do this as my table has 3000 rows..

    Thanks

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Provided that the course code is always the first character of the column, you can use the Mid function:
    Code:
    SELECT my, column, list FROM mytable
    WHERE Mid(mycoursecode, 2) = "CRC011"
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •