Group a query by current month

[ktnztigers]

Hello

Trying to group data in to month to date which is across multiple weeks. When I put dates between (eg. between 01/06/2022 and 10/06/2022) it brings the data through but on two lines - first line week 1 second line week 2. How do I get the query to group them together please?

Currently have it set as

SELECT TBL_CSBSUMMARY.[Staff Name:TM Name], Sum(TBL_CSBSUMMARY.Checks) AS SumOfChecks, Sum(TBL_CSBSUMMARY.Passes) AS SumOfPasses, Sum([Passes])/Sum([Checks]) AS PRC
FROM TBL_CSBSUMMARY
GROUP BY TBL_CSBSUMMARY.[Staff Name:TM Name], TBL_CSBSUMMARY.[Date of Observation]
HAVING (((TBL_CSBSUMMARY.[Date of Observation]) Between #6/1/2022# And #6/9/2022#));

 

[Joe4]

Welcome to the Board!

It looks like you are grouping by date:

GROUP BY TBL_CSBSUMMARY.[Staff Name:TM Name], TBL_CSBSUMMARY.[Date of Observation]

You should rather create a calculated field to get the month, and group on that instead.