count funtion in a select query...

G

Greta

Hi There: I have a query A(contains Date,Type,Especifcs,Comments) that left
joins a table A(Type Specifics) to create another query B.Query B returns all
values in Type and Especifics and a count.
eg.
Type Specifics Count
EPR Error 2
EPR Validate 0
EPR Other 6
Outlk Logon 0
Outlk Other 6
PAS Reports 0
PAS Other 6
Everything is as expected except that the counts get repeated in other rows.
That is eventhough the count of 6 corresponds to EPR, it shows up in the
other rows also that contain the same word in the specifics column. What must
I do for the count to return the value to its corresponding row???

SELECT DISTINCTROW [Options Specifics Software].Type, [Options Specifics
Software].Specifics, qryTSRCC_sw_rpt.Specifics, Count(qryTSRCC_sw_rpt.Date)
AS CountOfDate
FROM [Options Specifics Software] LEFT JOIN qryTSRCC_sw_rpt ON [Options
Specifics Software].Specifics = qryTSRCC_sw_rpt.Specifics
GROUP BY [Options Specifics Software].Type, [Options Specifics
Software].Specifics, qryTSRCC_sw_rpt.Specifics;

Thanks in advance
Greta
 
Top