Summary report repeats data
Tech-Archive recommends: Fix windows errors by optimizing your registry
Date: Thu, 24 Jun 2004 06:38:01 -0700
I am trying to create a summary report with a number of fields containing various DCount() functions. The report appears to work fine, however, it repeats the results for every single record in the underlying table. Is there a way I can prevent this from happening?
As far as I know, I cannot bind the report to a single query containing the required formulae as each one contains varying criteria.
Relevant Pages
- Re: Alternate sorting for Access report
... You use a single query but change the ... Your Resource For Help With Access, Excel And Word Applications ... like to be able to run the same report with the same input data, ...
(comp.databases.ms-access) - Re: Too much data?
... > report on a single query? ... I am trying to create a report which provides analysis from our MIS ... >> The report covers 20 sections, each swction takes 4Cm of vertical space. ... >> A total of 20 different queries are involved. ...
(microsoft.public.access.reports) - Re: Too much data?
... report on a single query? ... I am trying to create a report which provides analysis from our MIS ... > The report covers 20 sections, each swction takes 4Cm of vertical space. ... > A total of 20 different queries are involved. ...
(microsoft.public.access.reports) - Re: Export a reprot to Excel
... The export process will try to export the recordsource of the report. ... If you can create a single query based on the independent queries, ...
(microsoft.public.access.reports) - Re: indicate query values in form + relation
... yeses and nos. ... > Report ... > Brochure ... > Is this possible with one single query and one single form? ...
(microsoft.public.access.forms) |
|
