Grand Total on a Report

[Chad Cameron]

Hi All,

I have a couple of groups with subtotals in the footer. Is there a way to
get a grand total at the very end? I tried putting it in the footer, but it
give me a #name error. I cannot create a entire group can I?

Thanks
Chad

 

[Chad Cameron]

Sorry, the error is #Error not #Name

 

[John W. Vinson]

Sorry, the error is #Error not #Name

Correct the error in your expression.

If you would like help doing so, please post enough information that someone
who cannot see your database might have a chance of seeing what the error
might be. The #Name? flag means that you're referring to something (a
fieldname, a control, an expression...?) which Access cannot recognize;
perhaps a misspelling, or a name which should be in [square brackets] but
isn't, or the like.

 

[Chad Cameron]

Sorry John,

It worked in the footer for the group, but when I copied it out of the
footer into the page footer, it failed.

=Sum([Total Delay])

I am assuming i need to do a Sum of Sum([Total Delay]), but when I guessed
at it =Sum(Sum([Total Delay]), it failed. That is why I didn't put any code
in my message.

Thanks
Chad

Sorry, the error is #Error not #Name

Correct the error in your expression.

If you would like help doing so, please post enough information that
someone
who cannot see your database might have a chance of seeing what the error
might be. The #Name? flag means that you're referring to something (a
fieldname, a control, an expression...?) which Access cannot recognize;
perhaps a misspelling, or a name which should be in [square brackets] but
isn't, or the like.

 

[John W. Vinson]

Sorry John,

It worked in the footer for the group, but when I copied it out of the
footer into the page footer, it failed.

=Sum([Total Delay])

Use the Report Footer (which does allow sum expressions) rather than the Page
Footer (which doesn't).