Advertisement
Advertisement
| 05.28.2008 at 11:12AM PDT, ID: 23439037 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: |
SELECT tblDailyProduction.ProductionDate,( ([B26CarrierPerUnit])/60) AS [Carrier], (([B26CasePerUnit])/60) AS [Case],( ([B26DiffAssemblyPerUnit])/60) AS [Diff Assembly],(([B26InspectionPerUnit])/60) AS[Inspection], (([B26ShaftPerUnit])/60) AS [Shaft],( ([B26HousingPerUnit])/60) AS [Housing], (([B26AssemblyPerUnit])/60) AS [Assembly], (([B26LogisiticsPerUnit])/60) AS [Logistics] FROM qryB26RearAxleLogisticsPerUnit INNER JOIN (qryB26RearAxleShaftPerUnit INNER JOIN (qryB26RearAxleHousingPerUnit INNER JOIN (qryB26RearAxleAssemblyInspectionPerUnit INNER JOIN (qryB26RearAxleDiffAssemblyPerUnit INNER JOIN (qryB26RearAxleCasePerUnit INNER JOIN (qryB26RearAxleCarrierPerUnit INNER JOIN (qryB26RearAxleAssemblyPerUnit INNER JOIN tblDailyProduction ON qryB26RearAxleAssemblyPerUnit.ProductionDate = tblDailyProduction.ProductionDate) ON qryB26RearAxleCarrierPerUnit.ProductionDate = tblDailyProduction.ProductionDate) ON qryB26RearAxleCasePerUnit.ProductionDate = tblDailyProduction.ProductionDate) ON qryB26RearAxleDiffAssemblyPerUnit.ProductionDate = tblDailyProduction.ProductionDate) ON qryB26RearAxleAssemblyInspectionPerUnit.ProductionDate = tblDailyProduction.ProductionDate) ON qryB26RearAxleHousingPerUnit.ProductionDate = tblDailyProduction.ProductionDate) ON qryB26RearAxleShaftPerUnit.ProductionDate = tblDailyProduction.ProductionDate) ON qryB26RearAxleLogisticsPerUnit.ProductionDate = tblDailyProduction.ProductionDate GROUP BY tblDailyProduction.ProductionDate,( ([B26CarrierPerUnit])/60), (([B26CasePerUnit])/60),(([B26DiffAssemblyPerUnit])/60), (([B26InspectionPerUnit])/60),( ([B26ShaftPerUnit])/60), (([B26HousingPerUnit])/60), (([B26AssemblyPerUnit])/60), (([B26LogisiticsPerUnit])/60) HAVING (((tblDailyProduction.ProductionDate) BETWEEN [Forms]![frmDailyReport]![txtStartDate] AND [Forms]![frmDailyReport]![txtEndDate])) ; |