Re: Programming for footer section

Glad to hear that Marsh's suggestion works ... good luck!

--

Ken Snell
<MS ACCESS MVP>

"Linda Brown" <LindaBrown@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4CFFB15B-8F50-491B-8F06-D17C0D3DB07C@xxxxxxxxxxxxxxxx
> Actually, I had already done that. But remember that the section totals
> had
> different variables, depending on the totals that were grouped on weeks.
> I
> did some more searching last night and found Marshall Burton's suggestion
> was
> just what I needed:
>
> If you have to use code to calculate the number values, then
> add an invisible text box named txtRunValue to the detail
> section, Set its control source to =unboundtextboxname and
> its RunningSum property to Over All. The report footer text
> box can then display the sum by using the expression
> =txtRunValue
>
> I applaud all of you experts. A very warm thank-you to all of you who
> work
> to help us out. --Linda
>


.

Relevant Pages

  • Re: Sum on report
    ... Use a "Totals" query to sum, ... Good luck ... Jeff Boyce ... <Access MVP> ...
    (microsoft.public.access.reports)
  • Re: Still need help...
    ... > suggestion as to how to design better i would gladly ... >>might be and what type of data they are storing. ... >>MS Access MVP ... >>> can you please offer a suggestion instead of insulting ...
    (microsoft.public.access.queries)
  • Re: Aggregate message
    ... > FROM Query1 ... > GROUP BY.[Med RecNumber] ... >> MS Access MVP ... I have sum totals like this: ...
    (microsoft.public.access.forms)
  • Re: Averages
    ... will see that your suggestion will not work AUTOMATICALLY if I add further ... other entries. ... the other totals of Cols. ... Use colons, not semi-colons! ...
    (microsoft.public.excel.newusers)
  • Re: I just want a report summary
    ... >I am not creating a record for each child. ... >> MS Access MVP ... >>> I would like a report that totals how many children are in each age ... >>>>> make a report that simply has totals for each of field. ...
    (microsoft.public.access.reports)