Greetings...
I am trying to create a query that counts the # of One-on-One Reviews completed by Supervisor within a given date range
Problem is, (as most of you reading this have already figured out) adding the 'Totals' component to the Access Query Grid forces a group by on the date field et.al
Thus I return the count for each Supervisor for each date in the date range - Can't believe there isn't a way to do this
I've tried using Sum and about EleventeenHundred other itterations - Result - Here I am...
Below is the latest effort which produces the aforementioned results (Counts by date instead of total count for date range)
Code:
SELECT SubCorrectiveAction.DateActionIssued, MainCorrectiveAction.EnteredBy, SubCorrectiveAction.TypeOfAction, Count(MainCorrectiveAction.EnteredBy) AS Total
FROM (MainCorrectiveAction INNER JOIN SubCorrectiveAction ON (MainCorrectiveAction.[Corr-ID] = SubCorrectiveAction.[Corr-ID])
AND (MainCorrectiveAction.AssocID = SubCorrectiveAction.AssocID)) INNER JOIN tri_vAssocView ON SubCorrectiveAction.AssocID = tri_vAssocView.Assoc_ID
GROUP BY SubCorrectiveAction.DateActionIssued, MainCorrectiveAction.EnteredBy, SubCorrectiveAction.TypeOfAction
HAVING (((SubCorrectiveAction.DateActionIssued)>=#2/1/2020#) AND ((SubCorrectiveAction.TypeOfAction)="One-on-One Review"));
As always - Thank You so much for any help.
Rt91