Prev: Background picture for the whole page (incl. margins)
Next: IIf - Sum Problem
From: granola911 via AccessMonster.com on 28 Dec 2009 16:42
Hi,

thanks, that is exactly what I'm going to do.

Duane Hookom wrote:
>You can't use Sum() to total a control as it only works on fields or
>expressions from the report's record source. Also, you can't use Sum() of
>anything in a Page Footer (only works in Detail, Report, and Group sections).
>You might be able to try a running sum on the control in the section
>containing the subreport.
>
>I still feel it is generally easier to create a totals query and add it to
>the report's record source.
>
>> Hi
>> thanks for the input... there are some special underlying reasons why in this
>[quoted text clipped - 19 lines]
>> >>
>> >> .

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

First  |  Prev  | 
Pages: 1 2
Prev: Background picture for the whole page (incl. margins)
Next: IIf - Sum Problem