SELECT COUNT(CallType) AS call_count
FROM tblLog
WHERE CallType = 'Software/May-PS' OR CallType = 'Report Regeneration-PS' OR CallType = 'Training/Info-PS';
I want to show the Count of each individual week in the data base
You might want to verify syntax with the Access forum, then, because there is a difference between the T-SQL used with SQL Server (which is what this forum is for) and the SQL used in Access. If you use the wrong syntax, you won't get the results you want.
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
SELECT datepart("ww",DateLogged) as Week_Number,
COUNT(CallType) AS call_count
FROM tblLog
WHERE CallType = 'Software/May-PS' OR CallType = 'Report Regeneration-PS' OR CallType = 'Training/Info-PS'
Group By datepart("ww",DateLogged);
I want to also calculate the % of total calls for the week call_count is
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.