Number of Occurrences In A Month

.Justin

Registered User.
Local time
Today, 11:02
Joined
Jun 29, 2009
Messages
38
I am trying to calculate the number of occurrences in a month. Collum B holds the date, I want to work out how many times something has occurred in a month. So if there are 9 entries for January and 4 for February I want to be able to calculate this, however, I cannot work out a way to do this using a formula and don't particularly want to use a Pivot table.

:banghead: It's probably really simple but I am being really thick...
 
You do use a formula,
Add another field to format the date to Month.
Then run a pivot table,that what they're for.
 
Probably not a good idea to use pivot tables as they are not supported after Access 2010.

Maybe you can use the functions Month and MonthName in a expression in a aggregate query to do what you want. In the attached database I have some tables from the Northwind database that I use in an aggregate query to do what I'm suggesting. The data is grouped by type and month by using an expression. In this example:
Code:
Transaction Month: MonthName(Month([Transaction Created Date]))

The types are counted in this aggregate query.
 

Attachments

Users who are viewing this thread

Back
Top Bottom