VB Forum / Database Access / January 2006

Hi.
I have a question....

I have a very simple table

date             in(numerical)            out(numerical)

If my records in table were (the date format is italian-date):

datedoc                            in                      out
25/01/2006                       10                      3
28/01/2006                       6                        9
12/02/2006                       5                       2
23/02/2006                       15                     12

I would like to obtain this result

month                         total_in                total_out
jenuary                            16                        12
february                           20                        14

I've tried with a select like this:

SELECT
   DATEPART(YEAR,DATEDOC) AS ANNO,
   DATEPART(MONTH, DATEDOC) AS MESE,
   SUM(IN) AS [TOTAL_IN],
   SUM(OUT) AS [TOTAL_OUT]
FROM MYTAB
GROUP BY DATEPART(YEAR,DATEDOC) , DATEPART(MONTH, DATEDOC)
ORDER BY ANNO, MESE

but I get an error...
Is it possible to use datepart with mdb database???
Is this selection string wrong????

Any suggestion will be very appreciated!!!!