Count Per Month Problem in Sub-Report

[jnes006]

Hello

So I have a sub-report in Access 2010, and I need it to count the number of Cases each month.

My source query has two columns; Case_# and Date_Opened (example below)

C-1402 1/15/14
C-1403 1/16/14
C-1404 1/18/14
C-1405 1/18/14

My problem is a simple =Count([Case_#]) returns too few results.


Notably, the sub-report is in my report footer grouped on month.
My goal is to have each page in the report correspond to a month (e.g. Jan is page 1, Feb is page 2)

Any assistance is greatly appreciated.

[June7]

Is a subreport really necessary? Are the subreport Master/Child Links properties set?

Want to provide db for analysis? Follow instructions at bottom of my post.

[jnes006]

Is a subreport really necessary? Are the subreport Master/Child Links properties set?

Want to provide db for analysis? Follow instructions at bottom of my post.

Hi, thanks for your response. I tried a sub report based on its own query. The reason being, if I count the cases in the main report query I get duplicates included because I have a one-to-many field of Products. Essentially I need the duplicate cases on the main report, but not in the sub report. I will try to attach a version of the db. Thanks again