Query / report per month and year

[ripper]

Hi all.

I have a table with 5 fields, one of them is DATE.

In this table there are all the records regarding what has been sold.



What I need is a query that does this:

01.2011 > X items sold
02.2011 > X items sold
and so on.

In the DATE field, data is written in the "short form", so: DD/MM/YYYY (I'm from Switzerland and here the day is before month).

I wrote this:

SELECT DatePart('m',[Date]) & "." & DatePart('yyyy',[Date]) AS Expr1
FROM Eseguiti;

Which is what I want, but now I need to COUNT them!

Thanks for your help!

[Stingaway]

Hit the sigma symbol (group symbol) in design view on the query, put a Group by Expr 1 and then put the same expression in the next column but make it a Count.

[ripper]

Hit the sigma symbol (group symbol) in design view on the query, put a Group by Expr 1 and then put the same expression in the next column but make it a Count.

What can I say?

THANK YOU!