Hi All,
This is the SQL statement to sum some filelds for a particular month.
[vba]SELECT CostCenter,DatePart('m',[Date]) &'-'& DatePart('yyyy',[Date]), SUM(Shots) AS 'Shots', SUM(ProductionQty) AS
'Prodn',SUM(CR) AS 'CR', SUM(`MR(a)`) AS 'M/R',SUM(DownTime),
SUM(OperatingTime),SUM(AvailableTime),SUM(PlannedDownTime), SUM(PerformanceLoss),SUM(TotalAvailability) FROM
Logbook WHERE WorkingStatus='Working' AND DatePart('m',[Date]) &'-'& DatePart('yyyy',[Date])='5-2007' AND
Operation='Casting' OR Operation='Finish Turning' OR Operation='Cam Hole Boring' OR Operation='Boring' OR
Operation='Facing & Boring' OR Operation='D & T' OR Operation='Tapping & Boring' OR Operation='Facing & Dowling' OR
Operation='S_Facing & Boring' OR Operation='S. Facing & Tapping' OR Operation='10H8 Boring' OR Operation='10H8 &
Machining' OR Operation='All' OR Operation='Milling' OR Operation='Sensor Hole' OR Operation='Turning' OR
Operation='Grinding' OR Operation='Painting' GROUP BY DatePart('m',[Date]) &'-'& DatePart('yyyy',[Date]),CostCenter
ORDER BY DatePart('m',[Date]) &'-'& DatePart('yyyy',[Date])[/vba]
The problem is it sums for Apr-2007 as well. My Access db contains data for Apr-2007 and May-2007. Any idea why it sum for Apr-07 too?
Any help would be appreciated.