Recent content by souljacked

Thanks but that didn't seem to work. I'm no expert but I don't think transform is compatible with DISTINCT. Not that I even know what transform does :) This is my code TRANSFORM Count(PULLCALL.[ID&V Score]) AS [CountOfID&V Score] SELECT PULLCALL.Area FROM PULLCALL GROUP BY PULLCALL.Area...

I have a bog standard crosstab query that looks like this; Jan Feb Mar Apr Area1 6 9 21 11 Area2 9 14 26 18 Column heading - [Call Date] Row heading - [Area] Value - [AgentName] which I am counting. This data is...