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

report total problem

P: n/a
I have what I hope is a simple question for some of you. I have two
fields. Quantity and Price. I enter a text box named SubTotal in the
detail of the report and set the control source to
=[Quantity]*[Price]. This works fine and I have all the correct
values in the detail of the report. Now at the bottom of my report I
want a total. I insert a text box in the report footer named Total
and set the control source to =sum([SubTotal]). This does not work.
I get an "enter parameter" dialog box for SubTotal when the report
runs.

Any help?

Thanks

Mar 27 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 27 Mar 2007 05:53:31 -0700, "bobw2961" <bo******@hotmail.com>
wrote:

=Sum([Quantity]*[Price])

-Tom.

>I have what I hope is a simple question for some of you. I have two
fields. Quantity and Price. I enter a text box named SubTotal in the
detail of the report and set the control source to
=[Quantity]*[Price]. This works fine and I have all the correct
values in the detail of the report. Now at the bottom of my report I
want a total. I insert a text box in the report footer named Total
and set the control source to =sum([SubTotal]). This does not work.
I get an "enter parameter" dialog box for SubTotal when the report
runs.

Any help?

Thanks
Mar 27 '07 #2

P: n/a
On 27 Mar 2007 05:53:31 -0700, bobw2961 wrote:
I have what I hope is a simple question for some of you. I have two
fields. Quantity and Price. I enter a text box named SubTotal in the
detail of the report and set the control source to
=[Quantity]*[Price]. This works fine and I have all the correct
values in the detail of the report. Now at the bottom of my report I
want a total. I insert a text box in the report footer named Total
and set the control source to =sum([SubTotal]). This does not work.
I get an "enter parameter" dialog box for SubTotal when the report
runs.

Any help?

Thanks
By 'at the bottom of the report' I'll guess you mean the Page Footer,
not the Report Footer.

See Microsoft KnowledgeBase article:
132017 "How to sum a column of numbers in a report by page"
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Mar 27 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.