I need to pull data from one table by th following format:

Field1 field2 SummaryDataDate1 SummaryDataDate2

Table has:
Field 1
Field 2
Date
Errors

I need the number of errors for Date1 and the number of errors for date 2 etc.

Does this require a sub query? If yes How do I return just the single record for each column?

Thanks