Total by Product Column

[netrusher]

Below is the code that I have for a query. What I would
like to be able to do is somewhere in the query results
is show a total of Event Time for the Product Field.
Let's say there are 10 Fields for the same Product. I would
like to show a total of the Event_Times for that Product. I
would still like to see the 10 rows of information and then
a total. Any Suggestions?

SELECT TIME55.PRODUCT, TIME55.BUILD_ID, TIME55.PROCESS, TIME55.SOE_CODE, TIME55.EVENT_NUMB, TIME55.EVENT, TIME55.EVENT_TIME, TIME55.PRODUCT_DE
FROM TIME55
GROUP BY TIME55.PRODUCT, TIME55.BUILD_ID, TIME55.PROCESS, TIME55.SOE_CODE, TIME55.EVENT_NUMB, TIME55.EVENT, TIME55.EVENT_TIME, TIME55.PRODUCT_DE
HAVING (((TIME55.BUILD_ID)="l177"))
ORDER BY TIME55.PRODUCT, TIME55.PROCESS, TIME55.SOE_CODE, TIME55.EVENT_NUMB;

 

[SkipVought]

Hi

Notich that EVENT_TIME is not in the Groupb By clause...

SELECT
  TIME55.PRODUCT
, TIME55.BUILD_ID
, TIME55.PROCESS
, TIME55.SOE_CODE
, TIME55.EVENT_NUMB
, TIME55.EVENT[b]
, SUM(TIME55.EVENT_TIME)[/b]
, TIME55.PRODUCT_DE

FROM TIME55

GROUP BY
  TIME55.PRODUCT
, TIME55.BUILD_ID
, TIME55.PROCESS
, TIME55.SOE_CODE
, TIME55.EVENT_NUMB
, TIME55.EVENT
, TIME55.PRODUCT_DE

HAVING (((TIME55.BUILD_ID)="l177"))

ORDER BY
  TIME55.PRODUCT
, TIME55.PROCESS
, TIME55.SOE_CODE
, TIME55.EVENT_NUMB;

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[lespaul]

and you can UNION the two queries together to get the list and the total all in one!


Leslie

Essential for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[netrusher]

Skip,

Thanks but that is not giving me a total total, it is giving me a total of each row which I get if I Group By the Event_Time Field. I am looking for a total of all the Rows for when the Product Changes.

 

[netrusher]

Anybody still looking at this posting????

 

[SkipVought]

You want to same total value on multiple rows?

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}