I have a select query that uses a parameter query in the criteria pane of the date field. This query is linked to a report that uses a DCount function in a control on the report. When you run the report the DCount function produces an #ERROR result. If I change the criteria in the select query by removing the paramater query and manually entering a date in the criteria pane of the query, the DCount function in the report gives the proper result. Is there a conflict between domain aggregate functions and parameter queries?
I realize I can accomplish the same thing by creating a form with an unbound control for the user to enter the desired date and place a command button on the form to run the report. But I'm puzzled as to why the parameter query produces the #ERROR message. Anyone know?