Group records by Month? 1

[Simon22]

Hi all,
Can someone tell me if it is possible to group records by month? I would like my query to show the sum of clientordertotals ($) by month. For example:

January: $500
February: $1000

However, I can't seem to get Access to group by month.

Thanks for your help!

 

[Garridon]

I think what you're looking for is a cross tab query. Run the wizard for Cross tab queries and use the date as the column headings. It'll give you an option of by month, by quarter, etc.

Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

http://www.david-hedison.com

 

[Maquis]

Simon, you can groupby any field in your query. Just set up a field which returns just the month from your date field and use that. I think the syntax is Month([DateField]) Maq B-)
<insert witty signature here>

 

[Simon22]

Thanks. That second post is exactly what I wanted. Any way to get the month name instead of the month number?

 

[Maquis]

Look in Access help for the format and Datepart functions. One of them should do the trick. Maq B-)
<insert witty signature here>