Group by month!?

[kingz2000]

In oracle, I f I want a grouping by months this SQL works:

SELECT TO_CHAR(datum, 'Month') Month, sum(x) number
FROM table_A
where datum between '1.1.2005' and '31.3.2005'
GROUP BY to_char(datum, 'Month')

result:
january 45
february 60
march 33

How do I do the same for Access? Access doesn't seem to understand to_char, for example.
Thanks in advance.
Kingsley

 

[PCLewis]

Use Month(datum) to get the month number (1..12) or format(datum,"mmmm") to get the month name in full.