sql - 此表达式键入不正确，或者它太复杂而无法计算。SQL 访问

Question

SELECT
    "0" & "-" & a.G_DEPT AS LEVEL_NBR,
    "G: Omni_Dept" AS LEVEL_,
    "OMNI" AS CHANNEL_, 
    a.DIV,
    a.DIV_DESC,
    a.DEPT,
    a.DEPT_DESC,
    NULL AS COL1,
    NULL AS COL2,
    NULL AS COL3,
    NULL AS COL4, 
    NULL AS COL5,
    NULL AS COL6,
    NULL AS COL7,
    NULL AS COL8,
    NULL AS COL9,
    NULL AS COL10, 
    ROUND(AVG(a.NET_SLS_CST),2) AS NET_SLS_CST,
    ROUND(AVG(a.NET_SLS_OWN),2) AS NET_SLS_OWN, 
    ROUND(AVG(a.FIRST_SLS_TKT),2) AS FIRST_SLS_TKT, 
    ROUND(AVG(a.NET_SLS_TKT),2) AS NET_SLS_TKT, 
    SUM(a.OH_U) AS OH_U,
    SUM(a.OO_U) AS OO_U,
    SUM(a.NET_SLS) AS NET_SLS, 
    **SUM(CDbl(a.NET_UNITS)+CDbl(a.OH_U)) AS SO**
FROM
    ADMIN_DATA_TBL AS a
WHERE
    a.DEPT=[:hierNbr]
    AND
    a.STATUS=[:stat]
    AND
    a.TYLY='TY'
GROUP BY
    "0" & "-" & a.G_DEPT,
    a.DIV,
    a.DIV_DESC,
    a.DEPT,
    a.DEPT_DESC;

我在使用此语句时遇到问题（请参阅粗体/星号语句，SUM(CDbl(a.NET_UNITS)+CDbl(a.OH_U)) AS SO）它给了我这个错误：

此表达式键入不正确，或者它太复杂而无法计算。例如，一个数值表达式可能包含太多复杂的元素。

我试图删除铸件，但仍然是同样的问题。

标签： sqlms-access