Update Query summary

[Gismo]

Hi all,

Please help, i have a query that sums my data then from that i want to update a table with only the summary
Update queries does not seem to like running from a summary query
Why is this?
what is the work around on this one please?

 

[theDBguy]

Normally, you wouldn't want to store calculated values, because you should always just do the calculations whenever you need those values.

 

[Gismo]

Normally, you wouldn't want to store calculated values, because you should always just do the calculations whenever you need those values.

Agree, in this case I have to do Calculations from quite a few table then save them into a temporary table for report purposes, then deleted again

 

[CJ_London]

use an append query to your table, then cross tab it you get a horizontal summary