transform and insert

[etk]

I have a query that basically pivots some data. I want to get the result of this query into a table of its own, but I can't figure out why INSERT/UPDATE statements won't work with the TRANSFORM. The query is currently this:

TRANSFORM Max(tbl_Caller_tally.countof_empID) AS MaxOfcountof_empID
SELECT tbl_Caller_tally.CallerEmpID
FROM tbl_Caller_tally
GROUP BY tbl_Caller_tally.CallerEmpID
PIVOT tbl_Caller_tally.Yr_Mth;