title: Cannot join on Memo, OLE, or Hyperlink Object. using data from the server
body: <p>What the following code is supposed to be doing is taking each record from [ICBC] table and look for a matching in the [CIC TT Payment] table. But it is giving me a "Cannot join on Memo, OLE, or Hyperlink Object" type of error. Any idea on how to solve that?</p>
  
  <pre><code>    SELECT [CIC TT Payment].*, ICBC.*
      FROM ICBC INNER JOIN [CIC TT Payment]
      ON (ICBC.[贷方发生额] Between [CIC TT Payment].Monthly_Amt+200 And [CIC TT Payment].Monthly_Amt-200)
      AND ((ICBC.[个性化信息] Like "*" &amp; [CIC TT Payment].Plate &amp; "*")
      Or (ICBC.[个性化信息] Like "*" &amp; [CIC TT Payment].Contract &amp; "*"))
      AND ([CIC TT Payment].Contact_Date BETWEEN  DateAdd("d",-2,[ICBC].[交易时间]) AND DateAdd("d",2,[ICBC].[交易时间]));
  </code></pre>