Need to remove warning "Enter Parameter Value"

use the NZ function

Nz(FieldName,0)  for numeric type field

Nz(FeildName,"") for text type field

IUFoltzie,

You can't group by a field that is itself the result of a grouping.

In that, you can't group by:

[Sum Of Sum Of January]+[Sum Of Sum Of Febuary]+[Sum Of Sum Of March]+[Sum Of Sum Of April]+[Sum Of Sum Of May]

because these Sum of Sum of month are the result of group Sum of month.

Regards

So, following with my post before try this (I removed the grouped fields in the group clause):

SELECT DISTINCTROW tbl_cost_piw_title_type.[Work Type], tbl_cost_piw_title_type.Project_Application, tbl_cost_piw_title_type.[Cost Group ID], qry_CMPM_enhancing_FTE.[Cost Group ID], qry_CMPM_enhancing_FTE.PIW, Sum(qry_CMPM_enhancing_FTE.[Sum Of January]) AS [Sum Of Sum Of January], Sum(qry_CMPM_enhancing_FTE.[Sum Of Febuary]) AS [Sum Of Sum Of Febuary], Sum(qry_CMPM_enhancing_FTE.[Sum Of March]) AS [Sum Of Sum Of March], Sum(qry_CMPM_enhancing_FTE.[Sum Of April]) AS [Sum Of Sum Of April], Sum(qry_CMPM_enhancing_FTE.[Sum Of May]) AS [Sum Of Sum Of May], Sum(qry_CMPM_enhancing_FTE.[Sum Of June]) AS [Sum Of Sum Of June], Sum(qry_CMPM_enhancing_FTE.[Sum Of July]) AS [Sum Of Sum Of July], Sum(qry_CMPM_enhancing_FTE.[Sum Of August]) AS [Sum Of Sum Of August], Sum(qry_CMPM_enhancing_FTE.[Sum Of September]) AS [Sum Of Sum Of September], Sum(qry_CMPM_enhancing_FTE.[Sum Of October]) AS [Sum Of Sum Of October], Sum(qry_CMPM_enhancing_FTE.[Sum Of November]) AS [Sum Of Sum Of November], Sum(qry_CMPM_enhancing_FTE.[Sum Of December]) AS [Sum Of Sum Of December], Sum(qry_CMPM_enhancing_FTE.[Sum Of YTD Regular]) AS [Sum Of Sum Of YTD Regular], [Sum Of Sum Of January]+[Sum Of Sum Of Febuary]+[Sum Of Sum Of March]+[Sum Of Sum Of April]+[Sum Of Sum Of May] AS Sum_Actuals, (([Sum_Actuals]/152)/5) AS AVG_YTD_Actuals
FROM (qry_CMPM_enhancing_FTE LEFT JOIN tbl_cost_group ON qry_CMPM_enhancing_FTE.[Cost Group ID] = tbl_cost_group.[Cost Group ID]) RIGHT JOIN tbl_cost_piw_title_type ON qry_CMPM_enhancing_FTE.[Cost Group ID] = tbl_cost_piw_title_type.[Cost Group ID]
GROUP BY tbl_cost_piw_title_type.[Work Type], tbl_cost_piw_title_type.Project_Application, tbl_cost_piw_title_type.[Cost Group ID], qry_CMPM_enhancing_FTE.[Cost Group ID], qry_CMPM_enhancing_FTE.PIW
ORDER BY tbl_cost_piw_title_type.[Work Type], tbl_cost_piw_title_type.Project_Application;

Nz Function

You can use the Nz function to return zero, a zero-length string (" "), or another specified value when a Variant is Null. For example, you can use this function to convert a Null value to another value and prevent it from propagating through an expression.

Nz(variant, [valueifnull])

The Nz function has the following arguments.

Argument Description
variant A variable of data type Variant.
valueifnull Optional (unless used in a query). A Variant that supplies a value to be returned if the variant argument is Null. This argument enables you to return a value other than zero or a zero-length string.
Note   If you use the Nz function in an expression in a query without using the valueifnull argument, the results will be a zero-length string in the fields that contain null values.
 


If the value of the variant argument is Null, the Nz function returns the number zero or a zero-length string (always returns a zero-length string when used in a query expression), depending on whether the context indicates the value should be a number or a string. If the optional valueifnull argument is included, then the Nz function will return the value specified by that argument if the variant argument is Null. When used in a query expression, the NZ function should always include the valueifnull argument,

If the value of variant isn't Null, then the Nz function returns the value of variant.

Remarks
The Nz function is useful for expressions that may include Null values. To force an expression to evaluate to a non-Null value even when it contains a Null value, use the Nz function to return zero, a zero-length string, or a custom return value.

For example, the expression 2 + varX will always return a Null value when the Variant varX is Null. However, 2 + Nz(varX) returns 2.

You can often use the Nz function as an alternative to the IIf function. For example, in the following code, two expressions including the IIf function are necessary to return the desired result. The first expression including the IIf function is used to check the value of a variable and convert it to zero if it is Null.

varTemp = IIf(IsNull(varFreight), 0, varFreight)
varResult = IIf(varTemp > 50, "High", "Low")
In the next example, the Nz function provides the same functionality as the first expression, and the desired result is achieved in one step rather than two.

varResult = IIf(Nz(varFreight) > 50, "High", "Low")
If you supply a value for the optional argument valueifnull, that value will be returned when variant is Null. By including this optional argument, you may be able to avoid the use of an expression containing the IIf function. For example, the following expression uses the IIf function to return a string if the value of varFreight is Null.

varResult = IIf(IsNull(varFreight), "No Freight Charge", varFreight)
In the next example, the optional argument supplied to the Nz function provides the string to be returned if varFreight is Null.

varResult = Nz(varFreight, "No Freight Charge")
Example
The following example evaluates a control on a form and returns one of two strings based on the control's value. If the value of the control is Null, the procedure uses the Nz function to convert a Null value to a zero-length string.

Public Sub CheckValue()

    Dim frm As Form
    Dim ctl As Control
    Dim varResult As Variant

    ' Return Form object variable pointing to Orders form.
    Set frm = Forms!Orders

    ' Return Control object variable pointing to ShipRegion.
    Set ctl = frm!ShipRegion

    ' Choose result based on value of control.
    varResult = IIf(Nz(ctl.Value) = vbNullString, _
        "No value.", "Value is " & ctl.Value & ".")

    ' Display result.
    MsgBox varResult, vbExclamation

End Sub

Normally you use NZ in a query like this

Sum:NZ(Field1,0)+NZ(Field2,0)

this will avoid the error if any of the fields in the expression is Null or empty.

try it by adding fields with no value