Counting different valuesin one column

[genomon]

thread526-335324

Sorry for the roundabout response Steve but your original thread was closed by the time I came across it.
Will something like this work for you?

SELECT FirstTimeRejectCode, COUNT(FirstTimeRejectCode) AS RejectCount
FROM [AssyLineDB].[aProcess].[tblSerialNumber]
WHERE Rework=1
AND DateAdded BETWEEN @StartDate AND @EndDate
GROUP BY FirstTimeRejectCode