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