Thank you I had purchased AVG 9.0 for a 2 year period and after a few month it stopped working and interfered with other programs. As still reoccurring different issues point very probably to some hardware failures.Since AVG technicians could not fix it on a permanent basis. From AVG Free Forum:- How To Perform The Memory Test (Memtest)Edit: the code below will not work in MS-Access/Jet.
Not syntax checked and I am more familiar with T-SQL than MS-Access, but something like: UPDATE t2 SET t2. Mean Num From Table2 t2 INNER JOIN ( Select DISTINCT Table1.[MIU ID], Avg(Table1.[Avg RSSI] as Mean Num From Table1 GROUP BY Table1.[MIU ID] ) sub ON sub.[MIU ID] = t2. Although the lack of support for the update statement in Access is very sad this answers my question and I will resort to the standard fallback plan of using a temp table. Hello, Please try to remove AVG with AVG remover as described here: I also tried to disactivate it through a safe mode cmd line. No restore points and using the onboard system to retur to factory condition also fails.I have tried the following and variations of the following and the errors I'm getting are that it won't let me use Group By, and another error saying that Mean Num is not part of the aggregate function.Summary To reiterate all I'm trying to do is get the average of the Avg RSSI column in Table1 for each distinct MIU ID and insert each value into the appropriate row in Table2.