Count Items in a report

I have a parameter query to filter by date from which I run a report. I
need to be able to count the number of times a particular product or
error type appears after the report is run from the query. The products
and error types are limited to a defined list. I need to put these
summary totals in the footer. Using the Dcount function works, but
returns all items, not those within the date range.
Any assistance would be appreciated.

Miguel

.

Relevant Pages

  • Re: Use a form to query a report
    ... Selection" function to decide what records will be delivered to the report. ... If you filter for City, the report will be filtered for City. ... > need to do from here to complete the parameter query according to your ...
    (microsoft.public.access.gettingstarted)
  • Re: parameter query
    ... You could get the report you want by building a WhereCondition string to ... Use a multi-select list box to filter a report ... parameter query that displays many child records of one parent record ... I can't see how this could be done via a parameter query. ...
    (microsoft.public.access.queries)
  • Re: parameter query
    ... You could get the report you want by building a WhereCondition string to filter the report. ... parameter query that displays many child records of one parent record ... I can't see how this could be done via a parameter query. ...
    (microsoft.public.access.queries)
  • Report Filtering
    ... I have created a main report with 4 subreports. ... I have used the ApplyFilter macro action to filter the main and subreports. ... When I run the parameter query by itself, ...
    (microsoft.public.access.reports)
  • Re: Complex Grouping (I think) and totalling
    ... ItemDetail Table w/ ItemID (each ItemID is tied to Production Table's ... when setting the grouping in the report (top ... not getting the total count of that error type. ... I alread have a report that itemizes error types and totals per ITEM per ...
    (microsoft.public.access.queries)