From this code below....
SELECT DISTINCTROW Sum([Shift Report Table].Straighten) AS SumOfStraighten, Sum([Shift Report Table].Shine) AS SumOfShine, Sum([Shift Report Table].Standardize) AS SumOfStandardize, Sum([Shift Report Table].Sustain) AS SumOfSustain, Sum([Shift Report Table].Sort) AS SumOfSort, [Shift Report Table].Press, [Shift Report Table].Date, [Shift Report Table].Shift
FROM [Shift Report Table]
GROUP BY [Shift Report Table].Press, [Shift Report Table].Date, [Shift Report Table].Shift
HAVING ((([Shift Report Table].Press)=[Enter Press:]) AND (([Shift Report Table].Date)=[Enter Beginning Date:] And ([Shift Report Table].Date)=[Enter Ending Date:]) AND (([Shift Report Table].Shift)=[Enter Shift:]))
ORDER BY [Shift Report Table].Press, [Shift Report Table].Date;
....after i run this code, i want it to be able to add up the 5 different columns i have in here and show a total in one column. Right now this code gives me the total of each column and shows me in each individual column all at once. I want to have it show me just one seperate column showing the total of all 5 individual ones.
What code do i need to add to this to make that work?