Sorry, the database I use for my application is MS Access.
I've tried something like this.
SELECT SerialNumber AS SN,
(SELECT SUM(FinishedHours) FROM FollowUpTable WHERE FUDate BETWEEN
#07/01/2010# AND #07/05/2010# AND SerialNumber = SN
AND Department = "Shear") AS ShearTotal,
(SELECT SUM(FinishedHours) FROM FollowUpTable WHERE FUDate BETWEEN
#07/01/2010# AND #07/05/2010# AND SerialNumber = SN
AND Department = "Punch") AS PunchTotal,
(SELECT SUM(FinishedHours) FROM FollowUpTable WHERE FUDate BETWEEN
#07/01/2010# AND #07/05/2010# AND SerialNumber = SN
AND Department = "Break") AS BreakTotal,
(SELECT SUM(FinishedHours) FROM FollowUpTable WHERE FUDate BETWEEN
#07/01/2010# AND #07/05/2010# AND SerialNumber = SN
AND Department = "AS") AS ASTotal
FROM FollowUpTable WHERE FUDate BETWEEN #07/01/2010# AND #07/05/2010#
as you can see i'am using subqueries & it makes this very long difficult to read.
I hope everything is clear.
Thanks a lot!