Sum

  • Thread starter Thread starter Steven P via AccessMonster.com
  • Start date Start date
S

Steven P via AccessMonster.com

Hi,
I have a query which captures pieces ran on numerous machines which are
listed in row form. I then run another query to sum these into a final sum. I
have tried doing this with a sum expression with no luck. What do I need to
do so i don't have to run another query for a total sum?
Thanks
 
Make a one-field table with each machine placing its total into the table.
Have your final query bound to the table instead of sub-queries.

HTH
 
You must log in or register to reply here.

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

SUM in a UNION query 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Combine Duplicates in Query 0
Union query not displaying select statement 1
Incorrect sum in MS Access query 1
IIF Record = 5
Why do these two queries give me different answers? 3
Sums Way to big 7

Back
Top