counting values from a database

[Kurtismonger]

I have a database that contains production and status tables. The production table has part number, status_date and status_ID. The status table contains an entry for each status Id along with the quantity. Every day entries are made in it by part number showing the quantity of each part in each status. I can pull a query that shows all the entries for a given period of time, but I want to count them up and only show total numbers. So for example, rather than show each value entered for WidgetA for the past month, I was to show the total number of WidgetA's worked on as well as the subtotal of each status type. I'm thinking an array would be the way to go, but I'm not sure how to get started.

[NogDog]

Something like...

SELECT SUM(quantity) AS total,  blah...blah...blah GROUP BY part_number, status WITH ROLLUP

...?

[Kurtismonger]

Yeah...that gets me headed in the right direction. But it doesn't let me really control the presentation as subtotals for each part number are just additional lines without a status type. Also, one thing I didn't mention was that down the road I want to be able to drill down into the data and see individual entries say to find out what operator was working that day. I also want to be able to just look at totals by department. Thats why I was thinking it would be better to pull a larger dataset in and then count things up.