Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2010

    Unanswered: Query Calculation of Summed Columns

    I am trying to make a query that has the following fields:

    Item - Manhours - Quantity - Production

    Where the Item is a description
    Manhours is a sum in the totals row of the query
    Quantity is a sum in the totals row of the query
    and Production is a calculated field - Production: [SumOfDaily_Manhours]/[SumOfDaily_Quantity]

    When the query is run, it prompts me for "sum of daily manhours" and "sum of daily quantity". If i just hit enter on these then the query performs the calculations correctly, but is there a way to get rid of the prompts??

  2. #2
    Join Date
    Feb 2004
    One Flump in One Place
    Please can you supply the SQL of the query - we can't do much to debug without that.
    Also, do you run this by double clicking the query or running it from somewhere else?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts