Microsoft Access 2003 -正确布局代码

Question

SELECT DISTINCTROW [OEE/A Query].Press, Sum([OEE/A Query].[SumOfLabor Hours]) AS [Sum Of SumOfLabor Hours], Sum([OEE/A Query].[SumOfGood Pieces]) AS [Sum Of SumOfGood Pieces], Sum([OEE/A Query].[Scrap Pieces]) AS [SumOfScrap Pieces], Sum([OEE/A Query].[SumOfMachine Hours]) AS [SumOfSumOfMachine Hours], Sum([OEE/A Query].[Total Parts Hours Earned]) AS [SumOfTotal Parts Hours Earned], Sum([OEE/A Query].[Standard Pcs Expected]) AS [Stand Pcs Expected]
FROM [OEE/A Query]
GROUP BY [OEE/A Query].Press;
SELECT Sum(Sort)+Sum(Straighten)+Sum(Shine)+Sum(Standardize)+Sum(Sustain) AS total
FROM [Shift Report Table];

当我运行这段代码时，它产生了一个错误，即“在SQL语句结束后找到字符”。那么我该如何调整这段代码来避免任何错误呢？

Answer 1

Access查询不允许在同一窗口中有两个SELECT查询。所以你必须把你的两个查询分开。

我假设您使用的是Access查询设计窗口

Answer 2

我不确定，但我认为你不需要;这个角色。当你把它们拿出来的时候会发生什么？