Re: Results double when printing

I would think that you could create a totals query and use it as the record
source of a subreport. This would be much more efficient.
Place the subreport in the "Quarter" footer and link master/child on the
"Quarter" calculation.
--
Duane Hookom
MS Access MVP
--

"Steve Albert" <SteveAlbert@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2875C8F9-E4EA-47F0-B8DA-9AE11A81D961@xxxxxxxxxxxxxxxx
> Duane,
>
> How else would you sum values in a report where the text boxes are
> unbound.
> I thought you could not sum controls in a report?
>
> In a report, which is based on a query, I have a field called
> [TypeofComplaint]. I have other fields called [EnrollNoSchools],
> [PlacementNoSchools], [APENoSchools] , and [VacancyNoSchools], which are
> numbers. In the report, I want to have the total number of each of the
> fields
> for each [TypeofComplaint]. I can do it for only one of them, but I am
> having
> trouble doing it for all.
>
> The report would look like this, grouped by Quarter and then Type of
> Complaint:
>
> Q1-2005
>
> "Type of Complaint" "Number of Schools"
> Enrollment 14
> Placement 5
> APE 3
> Vacancy 4
>
> Total 26
>
> Thanks.
>
> - Steve
>
>
> "Duane Hookom" wrote:
>
>> You probably are not setting values back to zero in the On Print of your
>> report header section.
>>
>> Are you sure you need code to sum your values? I have rarely seen reports
>> where this is necessary.
>>
>> --
>> Duane Hookom
>> MS Access MVP
>> --
>>
>> "Steve Albert" <SteveAlbert@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:A9EF52A9-E722-46EC-9A35-E6092F0E91C2@xxxxxxxxxxxxxxxx
>> >I have a Grand Total in the Report Footer of my report that is found
>> >from
>> > "summing controls calculated by functions". This is the method I used
>> > from
>> > Microsoft's knowledge base, article id 208850. It all works fine,
>> > except
>> > for
>> > the problem below.
>> >
>> > When I use Print Preview, it calculates just fine. However, when I
>> > print
>> > the
>> > report, the Grand Total doubles in value. This does not happen to the
>> > Group
>> > Totals.
>> >
>> > Can anyone help?
>> >
>> > - Steve
>>
>>
>>


.

Relevant Pages

  • RE: Errors in Report total fields
    ... subtotal control ... Are PaymentTotal and ExpenseTotal in the REPORT footer of each subreport? ... reports to get their totals data from the fields of the report which come ...
    (microsoft.public.access.reports)
  • RE: Errors in Report total fields
    ... reports to get their totals data from the fields of the report which come ... two provide a subtotal for the main report. ... Subtract subreport 3 total from Main Report subtotal to get grand total: ... A button on the second form opens a preview of the invoice report. ...
    (microsoft.public.access.reports)
  • RE: Errors in Report total fields
    ... reports to get their totals data from the fields of the report which come ... two provide a subtotal for the main report. ... Subreport 1 gives work hours total ... A button on the second form opens a preview of the invoice report. ...
    (microsoft.public.access.reports)
  • RE: Errors in Report total fields
    ... Subreport" for the expense subreport. ... A main report can have controls on it. ... One type of control you can add to a report ... reports to get their totals data from the fields of the report which come ...
    (microsoft.public.access.reports)
  • RE: Errors in Report total fields
    ... Invoice Payments Subreport ... expect you are dealing only with "report" objects. ... The Name property of your subreport control: ... reports to get their totals data from the fields of the report which come ...
    (microsoft.public.access.reports)
Loading