下面的代码应该做的是从[ICBC]表中获取每条记录,并在[CIC TT付款]表中查找匹配项。但它给了我"无法加入备忘录、OLE 或超链接对象"类型的错误。关于如何解决这个问题的任何想法?
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 "*" & [CIC TT Payment].Plate & "*")
Or (ICBC.[个性化信息] Like "*" & [CIC TT Payment].Contract & "*"))
AND ([CIC TT Payment].Contact_Date BETWEEN DateAdd("d",-2,[ICBC].[交易时间]) AND DateAdd("d",2,[ICBC].[交易时间]));
尝试在备注字段上应用左:
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 ((Left(ICBC.[个性化信息],255) Like "*" & [CIC TT Payment].Plate & "*")
Or (Left(ICBC.[个性化信息],255) Like "*" & [CIC TT Payment].Contract & "*"))
AND ([CIC TT Payment].Contact_Date BETWEEN DateAdd("d",-2,[ICBC].[交易时间]) AND DateAdd("d",2,[ICBC].[交易时间]));