I need help dividing two columns in Access. To give you an ideas what I am doing: I need to group by Model Type, sum of all hours for each model type, and count of tasks per model. My result in column 4 should give me Labor Hours per Mode/ task count. When i build an expression in the 4th column it tells me to enter a parameter value, so I am thinking my query is wrong. But here is my sql:
SELECT QRY_8_12_16_w_Count_Task_Sum_Mod.[Model/Test], Sum(QRY_8_12_16_w_Count_Task_Sum_Mod.[SumOfDebriefed Labor Hours]) AS [SumOfSumOfDebriefed Labor Hours], Count(QRY_8_12_16_w_Count_Task_Sum_Mod.[Task Number]) AS [CountOfTask Number]
FROM QRY_8_12_16_w_Count_Task_Sum_Mod
GROUP BY QRY_8_12_16_w_Count_Task_Sum_Mod.[Model/Test];
Please help as I am struggling with this simple query.
Thanks
SELECT QRY_8_12_16_w_Count_Task_Sum_Mod.[Model/Test], Sum(QRY_8_12_16_w_Count_Task_Sum_Mod.[SumOfDebriefed Labor Hours]) AS [SumOfSumOfDebriefed Labor Hours], Count(QRY_8_12_16_w_Count_Task_Sum_Mod.[Task Number]) AS [CountOfTask Number]
FROM QRY_8_12_16_w_Count_Task_Sum_Mod
GROUP BY QRY_8_12_16_w_Count_Task_Sum_Mod.[Model/Test];
Please help as I am struggling with this simple query.
Thanks