Grouping Issues

[g0009348]

Hi, Can somebody please advise why this query doesn't group the results.

TRANSFORM Count(pt_tbl.ServiceNo) AS CountOfServiceNo
SELECT pt_tbl.Project, IIf([Cat] Is Null,"Awaiting Catagory",[Cat]) AS Catagory
FROM pt_tbl INNER JOIN Late_Cat_tbl ON pt_tbl.ServiceNo = Late_Cat_tbl.Part
WHERE (((pt_tbl.Created) Between (DateAdd("d",-DatePart("w",Now())+3,Now()))-28 And DateAdd("d",-DatePart("w",Now())+3,Now())) AND ((pt_tbl.Late_Release)=True))
GROUP BY pt_tbl.Late_Release, pt_tbl.Project, IIf([Cat] Is Null,"Awaiting Catagory",[Cat]), Late_Cat_tbl.Description
PIVOT "Year" & Format([Created],"yy") & " week" & IIf(DatePart("ww",[Created],4,1)<10,"0" & DatePart("ww",[Created],4,1),DatePart("ww",[Created],4,1));

Instead of a single line for project with a count of late releases, i was hoping it would add them all together. Am I doing something clearly wrong?

Thanks in advance

 

[Micron]

Hard for me to say just looking at the sql, but maybe this is one of those cases where you need to do this as a totals query first, then transform it with another query.