Query that groups by month

[question]

In my database i have a count for each day, but i need to sum the total for each month and the total for the year on one report. THe months must be the columns so i have to use a cross tab query. Because the dates use month, day, year, when i query it will only group the days together, not the months. Is there a way to reformat the dates into month and year only and query off of that by each year? Thanks

[PEB]

Yeah,

The way is to use the functions

Year([Yourdate])
Datepart("m",[YourDate])
Datepart("yyyy" ,[YourDate])

in your query!

Best regards!

[question]

Is there a way to format Date Part so it displays the month names instead of the month by number? Thanks.

Yeah,

The way is to use the functions

Year([Yourdate])
Datepart("m",[YourDate])
Datepart("yyyy" ,[YourDate])

in your query!

Best regards!

[question]

Nevermind, I formatted it and it separated the month by itself. Thanks

Is there a way to format Date Part so it displays the month names instead of the month by number? Thanks.

[sanniep]

Nevermind, I formatted it and it separated the month by itself. Thanks

The Datepart function does not recognize monthnames, the function Format does; Format([YourDate];"mmmm")..