Re: Sum of calculated fields

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

Great siiggghhh of relief.

Thanks for posting back with your final results, I was
concerned that I had misunderstood the problem and was
leading you astray. It's good to know that I was wrong when
I thought I might have made a mistake ;-)
--
Marsh
MVP [MS Access]


Chris B via AccessMonster.com wrote:
>Whoops!
>I was a little premature in my excitement, after compacting and repairing it
>bugged out as you predicted,
>I reviewed all my expressions as you mention below, lost the "sum" and other
>unnessasary parts of the expressions, cleaned up, and now it definately works
>great!
>Thanks once again!!!!
>
>Marshall Barton wrote:
>>Well, I'm glad you got it to work, but I have no idea what
>>that Sum is doing in there. I would have expected that to
>>either generate an error or cause the calculation to fly off
>>the rails. I probably still don't fully understand what you
>>want here, but regardless of my lingering confusion, you do
>>not need the [Forms]![tblemployee]![tbldetails].[Form]! part
>>of the expression, just =Nz(Sum([overtime]),0) should be
>>sufficient.
>>>Marshall You are the greatest!!!!!
>>>Got it right thanks to your help,
>>[quoted text clipped - 27 lines]
>>>>>>>>not aware of controls within the form/report. I suspect
>>>>>>>>that this is the cause of the #Error you are seeing.

.

Relevant Pages

  • Re: Sum of calculated fields
    ... I was a little premature in my excitement, after compacting and repairing it ... I reviewed all my expressions as you mention below, lost the "sum" and other ... Marshall Barton wrote: ...
    (microsoft.public.access.formscoding)
  • Re: Calculating Time Sheet
    ... formatting them that will return a numeric data type rather than a string ... so you can then use the values in arithmetical expressions: ... If so you can't sum the values of course you'd have to add the values ... these daily totals, or alas convert them so they can be totalled. ...
    (microsoft.public.access.gettingstarted)
  • Re: Sum of calculated fields
    ... expressions I used so that it may make better sense, ... This database is used to calculate normal working hours and overtime hours, ... I have managed to get the sum() of Total hours to display in the report ...
    (microsoft.public.access.formscoding)
  • Re: Ultimate debunking of Cantors Theory
    ... >>> expressions like ... >> Where do I find that expression in a set theory book? ... The partial sums can be determined, but the sum cannot be determined at ... only value with which you can extend the domain. ...
    (sci.math)
  • Re: Prolog Programming for AI, problem 7.1
    ... expressions with numbers and symbols. ... simp(X, (Sum, Vars), ):- integer, New is Sum+X. ... simp(X, (Sum, Vars), ):- atom, ... pretty, Tmp). ...
    (comp.lang.prolog)