Results 1 to 3 of 3
  1. #1
    Amerigo is offline Novice
    Windows 98/ME Access 97
    Join Date
    Mar 2011
    Posts
    24

    Where clause

    Hey All



    Trying to add another Where clause

    WHERE BBG_TradeID is not used in table tblBBG already

    I can't do indexes, caz blank values are fine


    Code:
     
    UPDATE
     tblCONCORD INNER JOIN tblBBG
     ON (tblBBG.BBG_ISIN=tblCONCORD.CONCORD_ISIN)  
    AND (tblBBG.BBG_Price=tblCONCORD.Price) 
     SET tblBBG.BBG_TradeID = tblCONCORD.Trade_ID
     WHERE BBG_TradeID ='';

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    Quote Originally Posted by Amerigo View Post
    WHERE BBG_TradeID is not used in table tblBBG already
    can be denoted like so:
    Code:
    WHERE BBG_TradeID NOT IN (SELECT field from tblBBG)

  3. #3
    Amerigo is offline Novice
    Windows 98/ME Access 97
    Join Date
    Mar 2011
    Posts
    24
    Quote Originally Posted by ajetrumpet View Post
    can be denoted like so:
    Code:
    WHERE BBG_TradeID NOT IN (SELECT field from tblBBG)

    tx, i had, but for some reason i wanted use wrd "WHERE" twice
    stupid me...

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

Similar Threads

  1. WHERE clause - Longshot
    By shexe in forum Queries
    Replies: 1
    Last Post: 09-22-2010, 02:39 PM
  2. Where clause syntax
    By stupesek in forum Reports
    Replies: 7
    Last Post: 09-03-2010, 02:26 PM
  3. update in where clause
    By mikensu in forum Access
    Replies: 0
    Last Post: 03-16-2009, 07:19 AM
  4. IIF clause
    By Peljo in forum Queries
    Replies: 2
    Last Post: 02-05-2008, 11:22 AM
  5. Help on WHERE clause
    By QBCM in forum Programming
    Replies: 1
    Last Post: 12-19-2005, 08:43 PM

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