Sum of calculated fields


Please help,

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.

Any suggestions would be much appreciated!


--
Message posted via http://www.accessmonster.com
.

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 of calculated fields
    ... >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 ... >the report is generated. ... mention both a form footer and a report footer. ...
    (microsoft.public.access.formscoding)
  • 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)
  • Re: Sum not recoginzing a negative number
    ... You cannot use normal floating point math with date/time values. ... >I have a report in which I am attempting to calculate elapsed time. ... In my report I group the two events by day and sum them ...
    (microsoft.public.access.reports)
  • Re: =Sum([?]+[??])?
    ... >These are all Date/Time formats ... The time fields would of course be ... date/time fields so that you would have *ten records* in the table ... expression to format that sum. ...
    (microsoft.public.access.gettingstarted)