Report Question - Counting & Grouping

First of all, we have a database for all company customer cases (through out the whole year of 2006). Every case has its own priority level.

‘Priority’ column has three option, ‘High’, ‘Medium’, and ‘Low’.

We are new to Access, and we are trying group all the case month to month (group them by their created date) on separate pages. At the end of each monthly summary, we’d like to do a number count on ‘High’, ‘Medium’, and ‘Low’.

Here is a sample that we are trying to get to…

Sample Datebase,
Case #// Created Date// Priority Level
001 12/5/06 High
002 12/7/06 Low
003 12/3/06 High
004 12/1/06 Medium
005 11/9/06 Medium

Sample Report we are trying to get to...
Summary for December:
Case #// Created Date// Priority Level
001 12/5/06 High
002 12/7/06 Low
003 12/3/06 High
004 12/1/06 Medium

Total Case: 4
High Priority Case: 2
Medium Priority Case: 1
Low Priority Case: 1

your help will be very appreciated! :rolleyes: