的MS Access“不承认......作为一个有效的字段名”

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语句，我特林跑，我在断开前称为代码表格形式的组合框，此语法工作与其他SQL语句对我来说，我没有在WHERE之后有GROUP BY和PIVOT。我试图把后面的结果放在后面，但我仍然得到一个错误。谁能告诉我我做错了什么？

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; 

如果代码是一个整数，然后用Short代替Text(255)。