I'm attempting to summarize a report that was based on a query (qryDate) using the DCount function but I can't seem to get it to work correctly.
My query has a "Between [beginning date] And [ending date]" criteria associated with it and I think that's where the problem begins. Is it possible to use DCount to count the number of records associated with a field AND include a restraint on which records to count? I don't think so, but then again I'm still pretty green with Access.
Basically I've got a field in qryDate entitled "Service Type". The query asks the user for a beginning and ending date. At the bottom of the report for this query I want to include summary information that shows how many occurrences of each type of service type have occurred during the selected time period. Is this possible at all? Below is what I thought would work:
=DCount("[Incident ID]"."qryDate","[Service Type = 'Trash'")