This is what i have so far in the SQL code........

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

```

How do i add to this code another field that totals 5 separate other fields?

Here's what i think it might look like but I'm not sure.....

```
SELECT Sum(Sort+Straighten+Shine+Standardize+Sustain)
   SUM(Sort),
   SUM(Straighten),
   SUM(Shine),
   SUM(Standardize),
   SUM(Sustain),
FROM [Shift Report Table];

```