Number of Occurrences In A Month

[.Justin]

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...

 

[Ranman256]

You do use a formula,
Add another field to format the date to Month.
Then run a pivot table,that what they're for.

 

[sneuberg]

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:

Transaction Month: MonthName(Month([Transaction Created Date]))

The types are counted in this aggregate query.

 

[Ranman256]

This is an excel question, not access.

 

[sneuberg]

This is an excel question, not access.

Oops.

As an aside as I understand it Microsoft's solution for pivots charts in post Access 2010 databases is to use Excel.