I have a form that shows number of claims. The users want, at the bottom of the form, controls that reflect the count of claim for the prior month and then a count of claim for MTD. Since these are unaboug, I tried making a select query as the source for one of the count control, but it did not work. So. how can I get two controls to count items in the underlying table based on different critieria? The counts are separate from the individual detail data as reflected on the form, which shows only the detail for one clailm record at a time. This is an ACCESS 2003 database.
SELECT TblClaims.ClaimACHATM, TblClaims.ClaimMonth, TblClaims.ClaimYear, Count(TblClaims.ClaimDateReceived) AS CountOfClaimDateReceived
GROUP BY TblClaims.ClaimACHATM, TblClaims.ClaimMonth, TblClaims.ClaimYear
HAVING (((TblClaims.ClaimACHATM)="ACH") AND ((TblClaims.ClaimMonth)=Month(Date())) AND ((TblClaims.ClaimYear)=Year(Date())));