4 Replies Latest reply on May 17, 2006 10:32 AM by Newsgroup_User

    modifying multi image names

    Level 7
      Hi All

      I'm wondering if anyone can help with this. I have a field in my database
      that holds about 2000 image name. Each image ends with the characters 3.jpg
      E.G. MyImage3.JPG

      what I am trying to do is create an Update query to changes each of the
      image names from MyImage3.jpg to MyImage2.jpg

      I've been trying with an output query to an update query but I can't seem to
      get the part of trimming the 3.jpg off and adding the 2.jpg.

      Any ideas would be greatly appreciated.