need 1 query pulling 3 different count(totals)

[Kim T]

TotalCalls
CompletedCalls
RollOverCalls

DateStart
DateCompleted

I count total calls from Date Start; I get total CompletedCalls if DateStart
=DateCompleted; I get total RollOverCalls if DateCompleted>DateStart this is
on 3 different queries when I try to put as 1 query I cant get it to work
correctly need help please
KT

 

[Jeff Boyce]

Kim

Without a clear picture of the underlying data structure, it's hard to offer
specific suggestions.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[KARL DEWEY]

Try this ---
SELECT Count(Kim_T.DateStart) AS [Total Calls],
Sum(IIf(Int([DateStart])=Int([DateCompleted]),1,0)) AS CompletedCalls,
Sum(IIf([DateCompleted]>[DateStart],1,0)) AS RollOverCalls
FROM Kim_T;