Calculating on one query several different items

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"));
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top