update table1
set brand = 'Acer',Server_Size='Low-Range',Sales_Chl='Direct',CountQ1=Sum(Q1)
where brandid = 'Acer' and Q2_1_1 > 0 and Q3_1_1 > 0

in access it gives error as
You tried to execute a query that dosen't include Brand as an aggregate function.

Any idea..

Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.

Hi,
you can't use Sum in UPDATE query
Peko

Okay thanks. Then what i should do if i want to carry out such operation?

Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.

Rupen & peko!!

Offcourse you can use Sum in update query ;)




Cheers :)

vinod

HI Rupen & peko!!
 check help option with "Operation must use an updatable query."
you can find domain function for Update query

Hope this will help you


Cheers :)

vinod

There might be a more elegant way to do it, but, a common way I get around alot of aggregate issues and action query constraints is to do all of your agregations in one query, then do an update/delete/append in a second query.