RE: Calculating the Grand Total in the Report

Tech-Archive recommends: Fix windows errors by optimizing your registry

Make sure your text box is in the Report Header or Footer and not a Page
Header or Footer. The Running Sum should NOT be set to overall or over group.
Leave it as None.

This all assumes your field is a numeric field in your report's record source.

--
Duane Hookom
Microsoft Access MVP


"lil lam" wrote:

Hi,

I have a report. In the report, there is a field Current Market Value
(CMV), and I am trying to create a grand total for it at the header or
footer of the report.

I tried what was in the book:
-create a text box, and now i see 2 boxes with the following text in
it: Text#: and Unbound
-go to properties
-go to data tab
-enter formula in control source ---> =sum([field])
-change running sum to overall or group over

This hasnt been successful for me.
Can someone help?
It should be real simple, i dont know why its not working.
Can someone help?



.

Relevant Pages

  • Re: Counting and totaling from a subreport
    ... running sum I manage to get it to work. ... text box that displays the subreport total. ... report grand total calculation. ... subreport's footer and that the total does not appear on the ...
    (microsoft.public.access.reports)
  • Re: subreport/report total question
    ... In the subreport, move your DayTotal text box into the Report Footer ... Page Header ... job totals always match the Work_Date totals because it gives me a job ...
    (microsoft.public.access.reports)
  • Re: Repost-Still Suffering with Subreports
    ... I think you can kill your running sum and then sum your job cats in the ... so I built a small subreport on the Volunteer ... > footer of the Volunteer ... > I take that field name and go to the main report and put ...
    (microsoft.public.access.reports)
  • Re: Can Shrink and Grow = yes
    ... Here's what my report is like: ... Page Header ... Footer section, with closing signatures for letter ... KeepTogether property set, then the group will be split ...
    (microsoft.public.access.reports)
  • Re: Process not working on laptop
    ... I just figured out that Access10 is simply processing the ... report differently than Access97. ... Page Header section to the Page Footer section ends up coming ...
    (comp.databases.ms-access)