SQL query: put values of an attribute as columns

Question

I have a table errors(errorId, category, eDate).

I am trying to show as result the number of errors per week and categories. The query result should be something like:

Week    Category1    Category2
01      2            5 
02      0            20

Answer 1

The code I posted wasn't right. You need to look into Crosstab Queries in Access.

Answer 2

Access can't do pivots, as far as I know. In SQL Server you could do this with the PIVOT() construct.

Edit: Actually, take a look at this.