I have a report that uses the DCount function as such: =DCount("[Midd]","qry3ptMiddles","[Midd]='Middle'"
It works as expected if the criteria in the query's date field is typed into the query. However, if I change the query's date field criteria to use a parameter query that's to be input by the user,I get an #ERROR result in the DCount formula when I run the report. I know the syntax for the parameter query is correct, because the query gives the expected results. Why won't the DCount formulas work when the parameter query is used? Any help would be appreciated.