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