By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,849 Members | 2,361 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,849 IT Pros & Developers. It's quick & easy.

Grand Total Field On Report (Page Footer)

P: n/a
Kinda Confused to why i cant get a single text field to add up all the
Projects that are filtered Via a Query.
I Have a Query Based on a Projects Table.

The Query Have a Criteria To Select a Estimator, Which Then List all
the Projects that Estimator as worked on.

When Then Opens a List Type Report thats Shows all The Projects
Related to that User. and that Report Theres a Field called [Tender
Value]

What I Want is to to able to show a total tender value at the end of
the report.

I've tried putting a unbound text box on the report and set the
control source as following

=sum([Tender Value])

If i have the Text Box in the page footer i get the following message
shown in the text box in preview mode #Error

If I Move The Text Box the into the Header it seems to work, but i
don't up there,

and if i have it in the detail section it repeated its self and Re
Adds The Total Field on Each Other?
Why Wont It Work in the Page Footer?

Aug 1 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ARC
Wouldn't you want the totals box in the Report Footer, and not the Page
Footer?
Aug 1 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.