Update Query summary (1 Viewer)

Gismo

Registered User.
Local time
Today, 02:35
Joined
Jun 12, 2017
Messages
801
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

I’m here to help
Staff member
Local time
Yesterday, 16:35
Joined
Oct 29, 2018
Messages
14,594
Normally, you wouldn't want to store calculated values, because you should always just do the calculations whenever you need those values.
 

Gismo

Registered User.
Local time
Today, 02:35
Joined
Jun 12, 2017
Messages
801
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

Super Moderator
Staff member
Local time
Today, 00:35
Joined
Feb 19, 2013
Messages
12,926
use an append query to your table, then cross tab it you get a horizontal summary
 

Users who are viewing this thread

Top Bottom