Update table using Total Query

K

Karen

Hi,

I have a total query that I would like to update table fields with. The
query sums the revenue for each category by Exec. The table holds the totals
for that category by executive.
 
R

Rick B

Why would you need to store this in a table? If you can calculate it in a
query, then that is how you should do it. It is very rare that you would
want to store a calculated value in a table. What if one of the records
that makes up that total gets changed?
 
Top