Is there a workaround that will let you use SUM in an update query?

I'm getting the beloved 'Operation must use an updateable query message'.

Thanks.