Summing Calculated Fields

Hi! In my database form, I have several fields that are calculated. I want
the query to sum those fields but cannot do it. I get different error
messages so I am defining the fields in hopes that someone can help.

In the form:
Control Source for [TotalDue] is:
=([RegFee]+[RegPreConfFee]+[MealsTotal]+[GiftShopTotal]+[CEUFee]+[ScholContrib]+[AdvocContrib])

[BalDue1] is the remaining balance after the 1st payment – necessary because
some have 2 payments
Control Source for [BalDue1] is:
=([TotalDue]-[TotalPaid1])

[BalDue2] is the remaining balance after the 2nd payment – hopefully $0 but
occasionally not true so needs to be included in the report.
Control Source for [BalDue2] is:
=([TotalDue]-[TotalPaid1]-[TotalPaid2])

[GrdTotPaid] is the total of both payments.
Control Source for [GrdTotPaid] is:
=([TotalDue]-[TotalPaid1]-[TotalPaid2])

These work fine in the form or in a report showing individual records, but
when I try to sum the amounts for a cumulative report, I cannot get a sum for
the fields that used calculations.

Thanks in advance!

--
nhb -- nc
.

Relevant Pages

  • Re: Total a Sum Iff expression
    ... I would expect a control source in a Report or Group Header or Footer ... =Sum([Total Whelped Females]) ... Sum(), Avg, Countare aggregate functions. ...
    (microsoft.public.access.queries)
  • Re: Report Sum Totals On Last Page
    ... "Duane Hookom" wrote: ... > All you should need is a couple text boxes in your Report Footer section. ... use a control source of: ... >> fix works to a degree for me, what I ultimately would like is just a sum ...
    (microsoft.public.access.reports)
  • Re: Summing Text Box
    ... >I'm guessing that the textbox showing this is in the ... >StaffTotal are fields in the report. ... >Below the Control Source set the Running Sum to Over All. ...
    (microsoft.public.access.reports)
  • Re: SUM
    ... > What is in Sum of MachCosts1? ... I need the grand total of all the headers that ... They have some different calculations that aren't covered ... >>> You can't Sum a control in a report. ...
    (microsoft.public.access.reports)
  • RE: Get average using already calculated fields
    ... I am trying to sum a text box, of which the control source is a sum. ... "Duane Hookom" wrote: ... is important to understand the difference and accurately describe your report. ...
    (microsoft.public.access.reports)