[Solved] Total quantity by style

[cartoonjazz]

I appreciate any help that can be offered.
I have a table that shows skus including size, price and quantity listed vertically. I would like to generate a query that gives me quantity totals per style, grouping all items whose sku are the same before the first dash from the left.

table 1


result


thanks again

[UnklDonald418]

Try something like

Code: Select all

SELECT  LEFT("SKU", LOCATE( '-', "SKU")-1) AS "Style", SUM("qty") AS "Total"  FROM "Table1" GROUP BY "Style";

You may need to adjust the column names to match those in your table.

[cartoonjazz]

fantastic thanks so much works great