SQL Statement

[TyF]

I need to write an SQL statement that will
Group by Location and
Sum Total Weight
Sum Total Tons
Sum Total Amount

 

[KARL DEWEY]

SELECT Location, Sum([Weight]) AS Total_Weight, Sum([Tons]) AS Total_Tons,
Sum([Amount]) AS Total_Amount
FROM YourTable
GROUP BY Location;

 

[TyF]

Good Advice... I have everything so far but the group.

SELECT Location, Sum([Weight]) AS Total_Weight, Sum([Tons]) AS Total_Tons,
Sum([Amount]) AS Total_Amount
FROM YourTable
GROUP BY Location;
--
KARL DEWEY
Build a little - Test a little

I need to write an SQL statement that will
Group by Location and
Sum Total Weight
Sum Total Tons
Sum Total Amount