Microsoft Access 2003 - Laying out code correctly.

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];

When i run this code, it produces an error which is "Characters found after end of SQL statement". So how do i adjust this code to avoid any errors?

Answer 1

I'm not sure, but I don't think you need the ; character. What happens when you take them out?

Answer 2

Access queries don't allow you to have two SELECT queries in the same window. So you have to separate your two queries.

I'm assuming you are working in the Access query design window