T
That Crazy Hockey Dood
Good Morning Folks..
I have a problem that I cannot wrap my head around. Please evaluate the
following SQL:
SELECT
Sum([EOSetups]+[FBOrders]+[NewAccounts]+[NCR]+[OTML]+[Pieces]+[ShowsPacked]+[ILSQuotes]+[INTLQuotes]+[DoNotExceed]+[Emails]+[Orders]+[NACallbacks]+[KeyAcctSales]+[Notes]+[FollowUp]+[ICSIndexed]+[Mail]+[CreditProcessing]+[ConsumerCatalogs]+[ReturnedMail]+[PRP]+[HeldOrders]+[VCommerce]+[QAEdits]+[QMEvaluations]+[eBooks])
AS AdminTotal,
Sum([CallCenterCalls]+[OperationsCalls]+[AdministrationCalls]+[CostcoCalls]+[CSEmail]+[ILSEmail]+[INTLEmail]+[FaxOrders]+[EmlOrders]+[ILSFaxandEmailOrders]+[CDFEmail]+[CustCareEmail])
AS CallCenterTotal,
Sum([ProcessedTracers]+[OpsEmail]+[PIF]+[WIF]+[FaxedPL]+[Callbacks]+[CALetters]+[NoteCodeChanges]+[ShipdeskFU]+[NotesandFU]+[RSPONSEFU]+[FrtQuotes]+[HFForms]+[OSForms]+[CriticalCare]+[Returns]+[CCOPStoIC]+[PTOExpedited]+[PTOCancels]+[ACO]+[BNAirReq]+[SalesSupportCalls]+[SalesSupportEmail])
AS OpsTotal,
Sum([WorkOrders]+[BinderyShipments]+[BPNotes]+[FollowUps]+[EmailOrders]+[EmailCS]+[iPageOrders]+[TaschenYourPay]+[Allocations]+[IPSNewAcct]+[IPSFax]+[IPSEmail]) AS PubCareTotal, Sum(tblPayroll.Payroll) AS SumOfPayroll
FROM [Admin Activity_tbl], [Call Center Activity_tbl], CCOPS_tbl, [Pub
Care_tbl], tblPayroll
WHERE ((([Admin Activity_tbl].Yr)=[Forms]![Monthly CPT]![Yr]) AND (([Call
Center Activity_tbl].Yr)=[Forms]![Monthly CPT]![Yr]) AND
((CCOPS_tbl.Yr)=[Forms]![Monthly CPT]![Yr]) AND (([Pub
Care_tbl].Yr)=[Forms]![Monthly CPT]![Yr]) AND
((tblPayroll.Yr)=[Forms]![Monthly CPT]![Yr]));
Here is what should be happening. I should be getting back the summed
results for each "container". The results are not even close to what they
should be. What really throws me for a loops is that the following SQL
returns the correct results:
SELECT
Sum([EOSetups]+[FBOrders]+[NewAccounts]+[NCR]+[OTML]+[Pieces]+[ShowsPacked]+[ILSQuotes]+[INTLQuotes]+[DoNotExceed]+[Emails]+[Orders]+[NACallbacks]+[KeyAcctSales]+[Notes]+[FollowUp]+[ICSIndexed]+[Mail]+[CreditProcessing]+[ConsumerCatalogs]+[ReturnedMail]+[PRP]+[HeldOrders]+[VCommerce]+[QAEdits]+[QMEvaluations]+[eBooks]) AS AdminTotal
FROM [Admin Activity_tbl]
WHERE ((([Admin Activity_tbl].Yr)=[Forms]![Monthly CPT]![Yr]));
This tells me that I have something wrong with the first query. I guess
that I could use separate queries if need be but that doesn't seem efficient
to me. Help.
Thanks,
Jim
I have a problem that I cannot wrap my head around. Please evaluate the
following SQL:
SELECT
Sum([EOSetups]+[FBOrders]+[NewAccounts]+[NCR]+[OTML]+[Pieces]+[ShowsPacked]+[ILSQuotes]+[INTLQuotes]+[DoNotExceed]+[Emails]+[Orders]+[NACallbacks]+[KeyAcctSales]+[Notes]+[FollowUp]+[ICSIndexed]+[Mail]+[CreditProcessing]+[ConsumerCatalogs]+[ReturnedMail]+[PRP]+[HeldOrders]+[VCommerce]+[QAEdits]+[QMEvaluations]+[eBooks])
AS AdminTotal,
Sum([CallCenterCalls]+[OperationsCalls]+[AdministrationCalls]+[CostcoCalls]+[CSEmail]+[ILSEmail]+[INTLEmail]+[FaxOrders]+[EmlOrders]+[ILSFaxandEmailOrders]+[CDFEmail]+[CustCareEmail])
AS CallCenterTotal,
Sum([ProcessedTracers]+[OpsEmail]+[PIF]+[WIF]+[FaxedPL]+[Callbacks]+[CALetters]+[NoteCodeChanges]+[ShipdeskFU]+[NotesandFU]+[RSPONSEFU]+[FrtQuotes]+[HFForms]+[OSForms]+[CriticalCare]+[Returns]+[CCOPStoIC]+[PTOExpedited]+[PTOCancels]+[ACO]+[BNAirReq]+[SalesSupportCalls]+[SalesSupportEmail])
AS OpsTotal,
Sum([WorkOrders]+[BinderyShipments]+[BPNotes]+[FollowUps]+[EmailOrders]+[EmailCS]+[iPageOrders]+[TaschenYourPay]+[Allocations]+[IPSNewAcct]+[IPSFax]+[IPSEmail]) AS PubCareTotal, Sum(tblPayroll.Payroll) AS SumOfPayroll
FROM [Admin Activity_tbl], [Call Center Activity_tbl], CCOPS_tbl, [Pub
Care_tbl], tblPayroll
WHERE ((([Admin Activity_tbl].Yr)=[Forms]![Monthly CPT]![Yr]) AND (([Call
Center Activity_tbl].Yr)=[Forms]![Monthly CPT]![Yr]) AND
((CCOPS_tbl.Yr)=[Forms]![Monthly CPT]![Yr]) AND (([Pub
Care_tbl].Yr)=[Forms]![Monthly CPT]![Yr]) AND
((tblPayroll.Yr)=[Forms]![Monthly CPT]![Yr]));
Here is what should be happening. I should be getting back the summed
results for each "container". The results are not even close to what they
should be. What really throws me for a loops is that the following SQL
returns the correct results:
SELECT
Sum([EOSetups]+[FBOrders]+[NewAccounts]+[NCR]+[OTML]+[Pieces]+[ShowsPacked]+[ILSQuotes]+[INTLQuotes]+[DoNotExceed]+[Emails]+[Orders]+[NACallbacks]+[KeyAcctSales]+[Notes]+[FollowUp]+[ICSIndexed]+[Mail]+[CreditProcessing]+[ConsumerCatalogs]+[ReturnedMail]+[PRP]+[HeldOrders]+[VCommerce]+[QAEdits]+[QMEvaluations]+[eBooks]) AS AdminTotal
FROM [Admin Activity_tbl]
WHERE ((([Admin Activity_tbl].Yr)=[Forms]![Monthly CPT]![Yr]));
This tells me that I have something wrong with the first query. I guess
that I could use separate queries if need be but that doesn't seem efficient
to me. Help.
Thanks,
Jim