count different months

  • Thread starter Thread starter creeater
  • Start date Start date
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

project progress 1
Suming Up Time over the course of days 1
pick up characters to run query 3
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Reporting in Access 11
Grouping periods & running sum - PLEASE help if you can! 8
Sum Function that does not include 0 15
Date Split 2

Back
Top