Advertisement
Advertisement
| 05.19.2008 at 08:10AM PDT, ID: 23413976 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: |
SELECT tblDailyProduction.ProductionDate, qryRearAxleAssemblyPerUnitB26.RearAxleAsblyPerUnit/60 AS [Assembly], qryRearAxleAssemblyTotalHousingB26.TotalHousing /60 AS [Housing], qryRearAxleAssemblyShaftB26.ShaftPerUnitB26/60 AS [Shaft], qryDiffCarrierCasePerUnitB26.CarrierCasePerUnitB26/60 AS [Carrier], qryPerUnitBuildTimeStdDiffCarrierAssemblyB26.DiffCarAsemblyBuildTime/60 AS [Diff Assembly], qryDiffCasePerUnitB26.[DiffCasePerUnit B26]/60 AS [Case] FROM (((((tblDailyProduction LEFT JOIN qryRearAxleAssemblyPerUnitB26 ON tblDailyProduction.ProductionDate = qryRearAxleAssemblyPerUnitB26.ProductionDate) LEFT JOIN qryRearAxleAssemblyTotalHousingB26 ON tblDailyProduction.ProductionDate = qryRearAxleAssemblyTotalHousingB26.ProductionDate) LEFT JOIN qryRearAxleAssemblyShaftB26 ON tblDailyProduction.ProductionDate = qryRearAxleAssemblyShaftB26.ProductionDate) LEFT JOIN qryDiffCarrierCasePerUnitB26 ON tblDailyProduction.ProductionDate = qryDiffCarrierCasePerUnitB26.ProductionDate) LEFT JOIN qryPerUnitBuildTimeStdDiffCarrierAssemblyB26 ON tblDailyProduction.ProductionDate = qryPerUnitBuildTimeStdDiffCarrierAssemblyB26.ProductionDate) LEFT JOIN qryDiffCasePerUnitB26 ON tblDailyProduction.ProductionDate = qryDiffCasePerUnitB26.ProductionDate WHERE (((tblDailyProduction.ProductionDate) Between [Forms]![frmDailyReport]![txtStartDate] And [Forms]![frmDailyReport]![txtEndDate])) GROUP BY tblDailyProduction.ProductionDate, qryRearAxleAssemblyPerUnitB26.RearAxleAsblyPerUnit, qryRearAxleAssemblyTotalHousingB26.TotalHousing, qryRearAxleAssemblyShaftB26.ShaftPerUnitB26, qryDiffCarrierCasePerUnitB26.CarrierCasePerUnitB26, qryPerUnitBuildTimeStdDiffCarrierAssemblyB26.DiffCarAsemblyBuildTime, qryDiffCasePerUnitB26.[DiffCasePerUnit B26] ORDER BY tblDailyProduction.ProductionDate; |