Re: Query miscalculations, why?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Tue, 23 Aug 2005 11:44:09 -0700, "Evan Goldin"
<EvanGoldin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>Thanks John! That did it. I got rid of the totalling query, and used
>subreports directly with the individual queries. However, while this solved
>most of the problem, I ran into a new, smaller one. I used to set the Detail
>section to not be visible, because all my info is displayed in the Report
>footer (it sums all the data, and that's what I'm looking for). However, when
>I now set my Detail section to be invisible, the data changes! That never
>happened before, any ideas?
>
>

None whatsoever, since I have no idea how your report is structured
nor how you're doing the summing.

Please post some more details of your Report.

John W. Vinson[MVP]
.

Relevant Pages

  • Re: Locking in Queries for Reports
    ... individual queries. ... whenever a report on which that query is based is run the ... read-only so that it cannot be modified by accident so this doesn't happen? ...
    (comp.databases.ms-access)
  • Locking in Queries for Reports
    ... individual queries. ... whenever a report on which that query is based is run the ... read-only so that it cannot be modified by accident so this doesn't happen? ...
    (comp.databases.ms-access)
  • Re: search for old reports
    ... As the data changes so does the information displayed in a report. ... On the other hand if you just need to regenerate the report information, you would filter the records for the report. ... For instance, if you were looking at information on expenses, you would have expense charge records with a date that the expense was incurred. ... the report would use that criteria to display the information for that time period. ...
    (microsoft.public.access.reports)
  • Re: how do I save a report format in access 2000 to use again?
    ... The data changes but the format of the report stays the same. ... filter the existing report to the current quarter's data by ...
    (microsoft.public.access.reports)