Problem updating a table

[tware]

Hi All,

I'm having a problem. I'm trying to run an update query using another query.

Here are my queries:

(This is my totals query.)
SELECT LASTNAME, FIRSTNAME, SUM(HOURS) AS Total
FROM HOURS
GROUP BY LASTNAME, FIRSTNAME;

(This is my update query.)
UPDATE VOLUNTEERS
SET VOLUNTEER.HOURS = qryTotalHours.Total
FROM qryTotalHours
WHERE VOLUNTEER.LAST_NAME = qryTotalHours.LASTNAME
AND VOLUNTEER.FIRST_NAME = qryTotalHours.FIRSTNAME;

I'm getting a syntax error of (missing operator) in query expression 'qryTotalHours.Total FROM qryTotalHours.

Can someone please help me?

Thanks,

Trena

 

[ScottGem]

duplicate please delete