Results 1 to 3 of 3
  1. #1
    itm is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2011
    Posts
    69

    Question Trying to do a simple update statement but it will not work

    Hi,
    I amtrying to do a simple update statement but I get the following error message:"The multi-part identifier "a.IDGRP" could not be bound.
    "
    Do you have any idea what I can do, or am doing worng here?
    thank you

    Here is my code:



    Code:
    UPDATE
     [NAACOM].[dbo].[APVEN_Test2]
     
    SET a.IDGRP = b.IDGRP
          
    ,a.[TEXTSTRE1] = b.[TEXTSTRE1]
          
    ,a.[TEXTSTRE2] = b.[TEXTSTRE2]
          
    ,a.[TEXTSTRE3] = b.[TEXTSTRE3]
          
    ,a.[TEXTSTRE4] = b.[TEXTSTRE4]
          
    ,a.[NAMECITY] = b.[NAMECITY]
          
    ,a.[CODESTTE] = b.[CODESTTE]
          
    ,a.[CODEPSTL] = b.[CODEPSTL]
          
    From [APVEN_Test2] a
          
    INNERJOIN [ADDRESS UPDATE] b
       
    ON a.[VENDORID] = b.[VENDORID]
    Last edited by itm; 02-22-2012 at 07:32 AM.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    Google: multi-part identifier could not be bound

    Here is one http://aartemiou.blogspot.com/2009/0...ld-not-be.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    itm is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2011
    Posts
    69
    I looked at this site before (and a few others) and one it is talking about my alias being out of scope between the sub query and the outer query; adn two my query is a simple update query. I even tryed just updating the one field and it still gave me this error. Unfortuantly, I do not see how this would apply here, I was not able to make the connection. if you see, based on this, what I am doing wrong prease let me know.
    Thank you
    Last edited by itm; 02-22-2012 at 07:22 AM. Reason: errors

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

Similar Threads

  1. Simple SQL statement in VB
    By JFo in forum Programming
    Replies: 5
    Last Post: 10-05-2011, 09:55 PM
  2. Replies: 1
    Last Post: 07-30-2011, 07:58 AM
  3. Replies: 2
    Last Post: 07-20-2011, 02:01 PM
  4. is this a valid SQL statement ? (simple)
    By markjkubicki in forum Queries
    Replies: 1
    Last Post: 07-22-2010, 06:49 PM
  5. Replies: 2
    Last Post: 08-26-2009, 10:43 AM

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