count different months

C

creeater

Have a report which list Date Closed. I wish to create a count where it
counts the different months and gives the total. So say I have the
dates

1 Oct 03
5 Oct 03
23 Oct 03
1 Nov 03
2 Nov 03

So I wish it to count Oct only: Oct: 3


Query name and Report name are called Montly. Field name is called
Date Closed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a running total for last twelve months 0
Sum Function that does not include 0 15
Simple way to count by month? 3
count dates in multiple columns 3
Grouping periods & running sum - PLEASE help if you can! 8
DCOUNT Unique Values 2
excel formula 5
how to formulate as MMM-YY and yyyymm base on yyyymmdd ? 3

Top