SQL Sum+GROUP BY problem

[brainiack18]

Hi All,


First off, thank you for taking the time to help me. Here is my dilemma:

Assuming all the column and table names and spelled correctly, is there any reason why this bit of SQL code isn't working?

SELECT [SalesQty/Year].JPEPN
SUM ([SalesQty/Year].QuantityShipped)
FROM [SalesQty/Year]
GROUP BY [SalesQty/Year].JPEPN;

Thank you!

[brainiack18]

The error message says something like "Syntax error (Missing Operator)" I have double and triple checked that I spelled everything correctly.

[pbaldy]

Define "isn't working". I'd alias the field:

SELECT [SalesQty/Year].JPEPN
SUM ([SalesQty/Year].QuantityShipped) AS TotalShipped
FROM [SalesQty/Year]
GROUP BY [SalesQty/Year].JPEPN;

[pbaldy]

Sorry, missed this. You need a comma between the fields:

SELECT [SalesQty/Year].JPEPN,
SUM ([SalesQty/Year].QuantityShipped) AS TotalShipped
FROM [SalesQty/Year]
GROUP BY [SalesQty/Year].JPEPN;

[brainiack18]

Thank you, can't believe I missed the comma -_-

[pbaldy]

No problem. It's always the little things the trip us up.