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
 
Back
Top