What you want to do is "pivot your data into a crosstab report". This has
been covered several times so you should be able to find more information
if you search on either "pivot table", "crosstab" or "cross tab".
Here's how to do it for a week's worth of dates, I will let you extend it
to fit
Hello
right now I have a table which looks like this
(including duplicate entries)
Error Date
A0012004-07-08
A0012004-07-08
A2222004-07-08
A0012004-07-09
Now I query for the quantity one error occurs during a
day (select Date, Error,
Count(*) FROM table1 GROUP BY Date and E
