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.
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)
