annoying problem with a query

Here's my problem... I've created a query to pull the data I need but it is not updateable. However, the whole point of the query was to update a table with it... so I have a second query that pulls the data from the first and attempts to update the table.

All I can get it to do is error out and tell me I must have an updateable query. But I'm not trying to update the query, I'm trying to update the updateable table. (this is all in Access)

first query is:
SELECT
ROUND(Avg((report.onin+report.offin)/IIf((report.son+report.soff)=0,1,(report.son+repor t.soff))),2) AS ptotal,
EIDCrossRef.EID
FROM (report INNER JOIN agent ON report.aid = agent.AGENT_ID) INNER JOIN EIDCrossRef ON agent.SOCIAL_SECURITY_NO = EIDCrossRef.SSNNumber
WHERE report.date Between [start_date] And [end_date]
GROUP BY EIDCrossRef.EID;

update query is:
UPDATE
cmgscoresdvr_cmgresults_local cmgres
SET
cmgres.ADH = (
SELECT ptotal
FROM qryReportAvgsByDate
WHERE cmgres.EID=qryReportAvgsByDate.eid)
WHERE
cmgres.YEARMONTH=[YearMonth];

Any thoughts? what can I do?

Give the IUSR_computername user write permissions to your access db.

http://www.dougscode.com/forum4/topic.asp?TOPIC_ID=5