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

Access Report Footer displaying the sum of a text box values in the Detail in another text box in the page's footer

P: n/a
How can I (if I can) display the sum of a text box values in the Detail in
another text box in the page's footer?

For example, I have a text box called "txtPoints" in the detail which
displays the total points for a current activity. As it cycles through all
the activities it displays the various points for each activity.
In the page's footer I want to display the total points. Here's what I have
in the control source for the totals textbox:

=Sum([txtPoints].[Text])

but that doesn't work. Any suggestions?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Wed, 22 Sep 2004 23:17:03 GMT, Richard Hollenbeck wrote:
How can I (if I can) display the sum of a text box values in the Detail in
another text box in the page's footer?

For example, I have a text box called "txtPoints" in the detail which
displays the total points for a current activity. As it cycles through all
the activities it displays the various points for each activity.
In the page's footer I want to display the total points. Here's what I have
in the control source for the totals textbox:

=Sum([txtPoints].[Text])

but that doesn't work. Any suggestions?


Read Microsoft Knowledgebase article:
132017 'How to sum a column of numbers in a report by page'
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.