Sub-Totaling

[Guest]

I have a table with following columns:
tblDate, tblEmployeeID, tblBreakTime

There are 5-10 entries on one day. I would like combine the entries and
sub-total the BreakTime per date.

Can anyone help.

Thanks in advance
Mike Chamis

 

[Amy Blankenship]

http://www.datapigtechnologies.com/flashfiles/crosstab.html

HTH;

Amy

 

[Tom Ellison]

Dear Mike:

SELECT tblDate, tblEmployeeID, SUM(tblBreakTime) AS TotalBreakTime
FROM YourTable
GROUP BY tblDate, tblEmployeeID

A note about using prefixes. tbl is commonly used to denote a table. You
seem to be using it to denote the names of columns within a table.
Confusing to me, anyway!

 

[Guest]

Thanks for your help Tom...
Mike

Dear Mike:

SELECT tblDate, tblEmployeeID, SUM(tblBreakTime) AS TotalBreakTime
FROM YourTable
GROUP BY tblDate, tblEmployeeID

A note about using prefixes. tbl is commonly used to denote a table. You
seem to be using it to denote the names of columns within a table.
Confusing to me, anyway!

 

[Guest]

Great website Amy. Thanks for the tip.

http://www.datapigtechnologies.com/flashfiles/crosstab.html

HTH;

Amy