Re: Sum of calculated fields

Chris B via AccessMonster.com wrote:
>I have a database in to which start date/time and end date/time is entered,
>from this I have calculated fields which calculate the timeDiff, also another
>which calculates the time from a Midnight reference.
>A rate is entered and this calculates the amount of money due.
>This is all working perfectly, the problem is when I try to sum the
>calculated fields, I keep getting #ERRORs,
>I have tried to place the Sum() in both form footer as well as the report
>footer, I too have tried by placing the complete expression into the Sum
>(expression).
>Where else can I put the Sum(), I dont mind if its only ever displayed once
>the report is generated.
>I have read other threads and have tried by changing the Running sum property
>of my Sum text box to Over group and tried Over All, still no avail.


You are not very clear about what you are doing here. You
mention both a form footer and a report footer. While Sum
works the same in both situations, the RunningSum property
is only available in reports.

We need to know the names of the record source fields, the
calculated values and the related expression used to
calculate each value.

A rule you may (or may not) be violating is that the
aggregate functions (Count, Sum, etc) only operate on fields
in the form/report's record source table/query. They are
not aware of controls within the form/report. I suspect
that this is the cause of the #Error you are seeing.

--
Marsh
MVP [MS Access]
.

Relevant Pages

  • Re: sum a calculated field
    ... I'm not really clear on the point of summing a beginning balance. ... > have a report that list various insurance carriers and the amount of ar ... >> the source for the report, so you can sum it. ... >> and on preventing problems with calculated fields: ...
    (microsoft.public.access.reports)
  • Re: Sum Function
    ... in the query on which your report is based and sum those calculated fields ... employees that allowed me to isolate data by employee and then calculate ...
    (microsoft.public.access.reports)
  • Sum of calculated fields
    ... I have a database in to which start date/time and end date/time is entered, ... from this I have calculated fields which calculate the timeDiff, ... I have tried to place the Sum() in both form footer as well as the report ...
    (microsoft.public.access.formscoding)
  • Re: Report is making too many numbers
    ... My report is grouped by Vendor, then Project, ... source query before putting it in the report so every record shows). ... A Running Sum text box accumlates its total. ... I've got a problem with Sum Totals at the end of a report, ...
    (microsoft.public.access.reports)
  • RE: Crosstab query dynamic columns ala Duane Hookom
    ... "javablood" wrote: ... I was trying to sum in the footer. ... "Duane Hookom" wrote: ... not too worried about getting this aspect of the report to work because I ...
    (microsoft.public.access.reports)
Loading