Noob query issue

[nicolas jean]

Hi everyone,

I'm sorry to ask this question but i'm working on my query for 6 hours and i can't figure how to solve it...

Here is the table

2009;STATUS1;1
2009;STATUS1;2
2009;STATUS1;3
2009;STATUS2;6
2009;STATUS3;5
2009;STATUS2;9
2010;STATUS1;11
2010;STATUS1;12
2010;STATUS2;13

And i would like to have a report like that in one query.

2009 Count occurence of status 1
2009 Count occurence of status 2
2009 Count occurence of status 3
2010 Count occurence of status 1
2010 Count occurence of status 2
2010 Count occurence of status 3

Is it possible ??

Thanks a lot



Edited 2 time(s). Last edit at 01/05/2011 07:21AM by nicolas jean.