Microsoft Access 2003 - Laying out code correctly

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?

---

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

---

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