DSum with a paramter query

[JonathanT]

I have a report that is based on a parameter query. The parameter I am prompted to change is CurrYear when I run the report. There is no other criteria in the query.
The query is called "SelectYearQry", and the field I want to sum is CSRHours. Both of the following syntax produce errors when I try to sum the CSRHours field. =Sum([CSRHours]) or =DSum("[CSRHours]","SelectYearQry"). Both syntax work fine in a select query but not in a parameter query. Any help would be appreciated. Unable to post a copy of the database

[June7]

Post the entire SQL statement.

Maybe could apply filter to report instead of parameterizing query. I don't use dynamic parameter query.

Could also use report Sorting & Grouping features with aggregate calcs in textbox. This would allow display of detail data as well as summary calcs.

[JonathanT]

I was able to provide a condensed DB with all the relevant fields. To clarify, I want to sum a field on a report that uses a parameter query. The field to sum is "CSRHours" and the report is the YearSelectRpt".
DB attached

[Bob Fitz]

Is this what you're after:

[Micron]

@JohnathanT; why are the hours from the query formatted as currency in the report??
EDIT - I mean in the CSRHours textbox:

$#,##0.00;($#,##0.00)

[JonathanT]

It is exactly what I'm looking for but I don't see the field "TotalHrs" anywhere in the database. I'd like to sum other fields but I can't see how this one works so I can replicate it.

[JonathanT]

Micron, Just something I missed. Will correct it

[Bob Fitz]

It is exactly what I'm looking for but I don't see the field "TotalHrs" anywhere in the database. I'd like to sum other fields but I can't see how this one works so I can replicate it.

The control called TotalHrs is in the reports Footer Section but is hidden, so you will need to view the report in design view to see it.
EDIT:
BTW you only have fields in tables and queries. In forms and reports you have "Controls" e.g. textboxes, comboboxes which are bound to fields in the table/query that is used as the Record Source of the Form/Report

[JonathanT]

Thanks, Bob Works Great