Can I Use Sum() Function Along With Update Query?

[kingking]

I'm trying to use sum() along with UPDATE as shown below

UPDATE ALLDATA INNER JOIN [Total Data] ON ALLDATA.PanNumber=[Total Data].PanNumber SET ALLDATA.PLAForMonthPrevYear = sum([Total Data].PLAForMonth), ALLDATA.CENVATForMonthPrevYear = sum([Total Data].CENVATForMonth), ALLDATA.PLAUptoMonthPrevYear = sum([Total Data].PLAUptoMonth), ALLDATA.CENVATUptoMonthPrevYear = sum([Total Data].CENVATUptoMonth)
WHERE [Total Data].Month=Forms![FORM REPORT]!Combo3;

IT IS THROWING ERROR
PLS HELP ME

 

[Guus2005]

You have to create a subquery in which you group by and sum the necessary fields which you can use in your update query.