Help Dividing to columns

Huizar

Board Regular
Joined
Aug 11, 2016
Messages
94
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
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
I only see 3 fields, not 4, so it's hard to figure out what you mean.
QRY_8_12_16_w_Count_Task_Sum_Mod.[Model/Test]
QRY_8_12_16_w_Count_Task_Sum_Mod.[SumOfDebriefed Labor Hours]
QRY_8_12_16_w_Count_Task_Sum_Mod.[Task Number]
Did you post the entire statement?
PS special characters in a field or object name are not a good idea (/).
 
Upvote 0

Forum statistics

Threads
1,221,808
Messages
6,162,097
Members
451,742
Latest member
JuanMark10

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top