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