Grouping by month

[1510982]

Hi.
I have a birthday record fro which type is Date. How can I now Group and Count those records by the month they were born?

eg. january: 14
february: 22
...

10x for your kidness.

 

[Robbo1974]

You could use a crosstab query to display the number of birthdays for each month. Use the crosstab wizard, which is very good in situations like this.

Iain Robbo ;-)

 

[JohnLowell]

Are you doing this in a report?

 

[1510982]

Yes, on a report. I'll try to check the crosstab wizard, as soon as I find out what it is
I'll let you know the solution, l8r.

 

[JohnLowell]

You should just let the report do all the work.

Create a group in the Grouping/Sorting form that will evaluate to the month number (=Month([your date column])) and make sure Group Header is Yes and Group Footer is Yes.

This will sort and group them by month (Jan is 1 Feb is 2...)
In the group Header, you can format the [your date column] to show the Month name (=Format([your month column],"mmmm&quot).

In the group footer, create a text box that will sum or count the column you need for the month (=Sum([your column])).