质谱访问"does not recognise ... as a valid field name"

Question

TRANSFORM Count(Breakdown.Hours) AS CountOfHours
SELECT Breakdown.Description, Breakdown.Customer, Count(Breakdown.Hours) AS [Total Of Hours]
FROM Breakdown
WHERE Breakdown.Code = [Forms]![Pre-Break]![Code]
GROUP BY Breakdown.Description, Breakdown.Customer
PIVOT Breakdown.Day;

这是我想要运行的 SQL 语句，我有一个名为 Code 的预中断形式形式的组合框，此语法适用于我在其他 SQL 语句中，我在 WHERE 之后没有 GROUP BY 和 PIVOT。我尝试将 after 放在最后，但仍然出现错误。谁能告诉我我做错了什么？？

Answer 1

尝试将表单值显式声明为参数 - 当我尝试运行它时有所不同：

PARAMETERS [Forms]![Pre-Break]![Code] Text (255);
TRANSFORM Count(Breakdown.Hours) AS CountOfHours
SELECT Breakdown.Description, Breakdown.Customer, Count(Breakdown.Hours) AS [Total Of Hours]
FROM Breakdown
WHERE Breakdown.Code = [Forms]![Pre-Break]![Code]
GROUP BY Breakdown.Description, Breakdown.Customer
PIVOT Breakdown.Day;

如果 Code 是整数，则使用 Short 而不是 Text(255) 。