M
Michelle
I need to calculate the amount of time spent for all of the -sum catagories.
Is there a way to do it on this query?
SELECT PDIG.[Date Received], PDIG.[Associate Last Name], PDIG.[Associate
First Name], Sum(PDIG.[Time Spent]) AS [SumOfTime Spent], -Sum(PDIG.[C/R G/I
B/G Check]) AS CrGiBgChecked, -Sum(PDIG.[Database Check]) AS DatabaseChecked,
-Sum(PDIG.[NAFTA Check]) AS NAFTAChecked, -Sum(PDIG.[Referral Check]) AS
ReferralCheck, -Sum(PDIG.[Billing Record Check]) AS BillingRecordChecked,
-Sum(PDIG.[A/O]) AS AOChecked, -Sum(PDIG.[Electronics]) AS ElectronicsChecked
FROM PDIG
GROUP BY PDIG.[Date Received], PDIG.[Associate Last Name], PDIG.[Associate
First Name], PDIG.[Time Spent]
HAVING (((PDIG.[Date Received]) Between #1/22/2007# And #1/26/2007#) AND
((PDIG.[Associate Last Name])="deskiewicz"));
Is there a way to do it on this query?
SELECT PDIG.[Date Received], PDIG.[Associate Last Name], PDIG.[Associate
First Name], Sum(PDIG.[Time Spent]) AS [SumOfTime Spent], -Sum(PDIG.[C/R G/I
B/G Check]) AS CrGiBgChecked, -Sum(PDIG.[Database Check]) AS DatabaseChecked,
-Sum(PDIG.[NAFTA Check]) AS NAFTAChecked, -Sum(PDIG.[Referral Check]) AS
ReferralCheck, -Sum(PDIG.[Billing Record Check]) AS BillingRecordChecked,
-Sum(PDIG.[A/O]) AS AOChecked, -Sum(PDIG.[Electronics]) AS ElectronicsChecked
FROM PDIG
GROUP BY PDIG.[Date Received], PDIG.[Associate Last Name], PDIG.[Associate
First Name], PDIG.[Time Spent]
HAVING (((PDIG.[Date Received]) Between #1/22/2007# And #1/26/2007#) AND
((PDIG.[Associate Last Name])="deskiewicz"));