Sum in Query

[skwilliams]

I have a table with information and need a query to display the results in a specific format

I've attached an excel file which shows the table data and the query format needed.

Any ideas??

Thanks.

 

[davewhite04]

SELECT DISTINCTROW Table1.Category, Table1.Type, Sum(Table1.Total) AS [Sum Of Total]
FROM Table1
GROUP BY Table1.Category, Table1.Type;

Hope this helps.

 

[skwilliams]

Thanks.

But I need the Mc Blanks totaled, Mc Printed totaled, etc. They are still being split by date.

 

[skwilliams]

Thanks.

But I need the Mc Blanks totaled, Mc Printed totaled, etc. They are still being split by date.

 

[skwilliams]

Thanks.

But I need the Mc Blanks totaled, Mc Printed totaled, etc. They are still being split by date.

 

[davewhite04]

You need to remove the RecDate from the select statement. Just have Category, Type and Sum(I called it total).