Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    6

    Question Unanswered: Invalid Memo, OLE, or Hyperlink Object in Subquery 'Symbol'

    This statment works fine on a SQL server but will not work on my Access 2002 DB.

    SELECT Symbol FROM Active_Stock_List WHERE Symbol Not In (SELECT Symbol FROM dbo_Historical_Data WHERE Dt = Date());

    Any ideas???

    Thanks for your help!

    Matthew

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    The data type of Symbol seems to be not supported by Access.

Posting Permissions

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