Update Query summary

Gismo

Registered User.
Local time
Today, 15:06
Joined
Jun 12, 2017
Messages
1,298
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?
 
Normally, you wouldn't want to store calculated values, because you should always just do the calculations whenever you need those values.
 
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
 
use an append query to your table, then cross tab it you get a horizontal summary
 

Users who are viewing this thread

Back
Top Bottom