Update table using Total Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query to display highest totals 1
How do I get totals with blank fields (Nulls)? 1
SUM in a UNION query 2
Combine Duplicates in Query 0
Counting multiple memberships 1
Need to create totals using a Crosstab Query 3
Conditional query/report 0
Duplicates - Query Joining 1

Back
Top