Help with SQL Queries

[JavaToPerlNowVB]

I have these two queries and I would like to add "Units Inspected" column, which is in the second query to the first query. Is there away to do that, How could i do so...

Here are the queries

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

SELECT DatePart("yyyy",[INSPECTDATE]) AS [Inspection Year], Count(GISADM_INSPECTIONDATAPOLE.OBJECTID) AS [Units Inspected]
FROM GISADM_INSPECTIONDATAPOLE
GROUP BY DatePart("yyyy",[INSPECTDATE])
ORDER BY DatePart("yyyy",[INSPECTDATE]);

Thanks alot

 

[JerryKlmns]

Try in forum701

 

[JavaToPerlNowVB]

Out put of this query gives me four columns according to the actions that i have used to group. Is it possible for me to get a total(sum up) for each column at the end of each.

thanks