How do I count criteria from a dropdown list on a form in a Microsoft Access report?
Posted on 2014-02-12
I have a combo box linked to field "Case Contact Method" with "Face-to-Face", "Phone", and "Other" as the drop down list criteria. The user will click a button which will prompt for start and end date then run a report (based on a query) pulling first name, last name, and Case Contact Method. This list is populated. I have a total count for all contacts but would like a broken down count for each at the bottom of the report based on the dates provided in the date range prompt mentioned.
I believe this would require a DCount function but I cannot get the syntax right.