sql - Microsoft Access 备注字段在查询时被截断

Question

我过去 Access 过相同的备忘录字段并使用找到的注释 here以避免截断该字段。出于某种原因，我的新查询开始截断 Description 字段，但我无法找到导致截断的原因。

SELECT TableA.ID, Min(IIf([TableA].[YFLAG]="Y",[TableB].[CRHR],[TableA].[CRHR])) 
    AS [Min Credit], First(TableC.COU_DESC) AS Description
FROM (TableA LEFT JOIN TableC ON (TableA.END_DATE = TableC.END_DATE) AND 
    (TableA.ID = TableC.ID)) LEFT JOIN TableB ON TableA.ID = TableB.ID
GROUP BY TableA.ID
HAVING (((Min(IIf([TableA].[YFLAG]="Y",[TableB].[CRHR],[TableA].[CRHR])))>0));

我已将问题缩小到 Having 语句，但不确定如何解决。

Answer 1

我想知道使用这样的联合是否可行

SELECT TableA.ID,0 AS [Min Credit],TableC.COU_DESC AS Description WHERE (FALSE)
Union All
SELECT TableA.ID, Min(IIf([TableA].[YFLAG]="Y",[TableB].[CRHR],[TableA].[CRHR])) 
    AS [Min Credit], First(TableC.COU_DESC) AS Description
FROM (TableA LEFT JOIN TableC ON (TableA.END_DATE = TableC.END_DATE) AND 
    (TableA.ID = TableC.ID)) LEFT JOIN TableB ON TableA.ID = TableB.ID
GROUP BY TableA.ID
HAVING (((Min(IIf([TableA].[YFLAG]="Y",[TableB].[CRHR],[TableA].[CRHR])))>0));

这个“union all”欺骗 Access 根据您分享的链接保留整个备忘录字段。