Sum Function

[JavaToPerlNowVB]

I have this query and I want to include sum function to calculate the total of a column, I know how to use the sum function is a regular select statement but I am not sure how to add that to this query

TRANSFORM Count(OBJECTID) AS CountOfOBJECTID
SELECT DatePart("yyyy",[INSPECTDATE]) AS InspectionDate
FROM GISADM_GNDLINEFACILITYMAINTPOLE
GROUP BY DatePart("yyyy",[INSPECTDATE])
ORDER BY DatePart("yyyy",[INSPECTDATE])
PIVOT MAINTACTION;

PS: PHV, Can you give it a shot

thanks for all the help

 

[PHV]

Have you tried the crosstab query wizard ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[JavaToPerlNowVB]

I get columns according to the maintaction I want to add each column. I didnt find anything in the wizard. thanks