Sum Total in Text box of Report gives #Error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have a report with a text field named Amount. In the controlsource property
of the Amount field, I have =([CountOfDept ID])*50 which takes the number of
deptid?s times 50 . This is working fine, But now I need to total all the
amounts.

Now in the page footer, I want to total the amounts using =Sum([Amount]) in
the controlsource field on the page footer, but I get #Error.

Can any help me out with this??

Thanks,
Benny


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200509/1
.

Relevant Pages

  • Re: Create a running total
    ... >user selects check boxes next to amounts and it would be ... If you only want a total in the form's footer, ... MVP ...
    (microsoft.public.access.formscoding)
  • Re: page footer calculated field
    ... amounts etc. ... I have moved it from the section footer to the page footer. ... The problem is that the calculated fields are no long working on the ... Is there any way to have this calculated fields working on the page ...
    (microsoft.public.access.reports)
  • Re: CompUSA Wireless Router - WDS Config
    ... you keep up your good work that looks like it amounts to *nothing*. ... Duane, have you tried decaff? ... Prev by Date: ...
    (alt.internet.wireless)
  • Re: Oil Depot Buncefield near London On Fire
    ... sulpher diesel in large amounts and vaporised pertrol will explode. ... Prev by Date: ...
    (misc.survivalism)
  • Minimizing table length
    ... amounts of text in each cell. ... TIA ... Alex ... Prev by Date: ...
    (microsoft.public.word.tables)