Results 1 to 2 of 2
  1. #1
    willmannix123 is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Oct 2016
    Posts
    1

    I'm stuck on how to update a field using an update query in microsoft Access


    Basically in my database I have a field called tagNumber. the tag number has 3 letters and 5 numbers e.g PPY66655. My task is to use an update query to update any number in the tagNumber field with the letters FGR to IRE.

  2. #2
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    From : Left(TagNumber,3)="FGR" update to "IRE" & Right(TagNumber,Len(TagNumber-3))

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

Similar Threads

  1. Replies: 6
    Last Post: 04-16-2016, 10:18 AM
  2. Replies: 14
    Last Post: 01-27-2014, 12:33 PM
  3. Replies: 1
    Last Post: 05-17-2013, 12:53 PM
  4. Replies: 2
    Last Post: 08-30-2012, 07:59 AM
  5. Replies: 5
    Last Post: 12-16-2011, 11:38 AM

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
  •  
Other Forums: Microsoft Office Forums