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

Report Sum

P: n/a
DS
How do you get a sumon a calculated field in a detail section on a
report? I have a group footer that I need the sum on.
Thanks
DS
Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
You have to sum the calculation rather than refer to the name of the
calculated control (presumably a text box). So if your Detail section
contains a text box named "txtTotal" and that text box's Control Source is
"=[Price] * [Quantity]" then your sum has to be in a text box with the
Control Source "=Sum([Price] * [Quantity])" rather than "=Sum([txtTotal])
"DS" <bo******@optonline.net> wrote in message
news:7i*************@fe08.lga...
How do you get a sumon a calculated field in a detail section on a
report? I have a group footer that I need the sum on.
Thanks
DS

Nov 13 '05 #2

P: n/a
DS
Dave M wrote:
You have to sum the calculation rather than refer to the name of the
calculated control (presumably a text box). So if your Detail section
contains a text box named "txtTotal" and that text box's Control Source is
"=[Price] * [Quantity]" then your sum has to be in a text box with the
Control Source "=Sum([Price] * [Quantity])" rather than "=Sum([txtTotal])
"DS" <bo******@optonline.net> wrote in message
news:7i*************@fe08.lga...
How do you get a sumon a calculated field in a detail section on a
report? I have a group footer that I need the sum on.
Thanks
DS


Right, I tried that and I still get nothing. Am I doing something wrong?
Thanks
DS
Nov 13 '05 #3

P: n/a
DS
Dave M wrote:
You have to sum the calculation rather than refer to the name of the
calculated control (presumably a text box). So if your Detail section
contains a text box named "txtTotal" and that text box's Control Source is
"=[Price] * [Quantity]" then your sum has to be in a text box with the
Control Source "=Sum([Price] * [Quantity])" rather than "=Sum([txtTotal])
"DS" <bo******@optonline.net> wrote in message
news:7i*************@fe08.lga...
How do you get a sumon a calculated field in a detail section on a
report? I have a group footer that I need the sum on.
Thanks
DS


PS That calculated control is based on another calculated control.
DS
Nov 13 '05 #4

P: n/a
Aha! That makes it more complicated, but you can still do stuff like

=Sum(([Cost] + [Tax]) * [Quantity])

However, if it's getting to that point, you're probably better off to do as
much of the calculation as you can in a query that then supports the
report.. If you have a calculated field in a query that looks something
like Extension:([Cost] + [Tax]) * [Quantity]) you can then have a text box
for the Exetnsion field in your Detail section, and then a summary textbox
that uses =Sum([Extension]) in the appropriate footer(s).

"DS" <bo******@optonline.net> wrote in message
news:OO***************@fe08.lga...
Dave M wrote:
You have to sum the calculation rather than refer to the name of the
calculated control (presumably a text box). So if your Detail section
contains a text box named "txtTotal" and that text box's Control Source is "=[Price] * [Quantity]" then your sum has to be in a text box with the
Control Source "=Sum([Price] * [Quantity])" rather than "=Sum([txtTotal])

"DS" <bo******@optonline.net> wrote in message
news:7i*************@fe08.lga...
How do you get a sumon a calculated field in a detail section on a
report? I have a group footer that I need the sum on.
Thanks
DS


PS That calculated control is based on another calculated control.
DS

Nov 13 '05 #5

P: n/a
DS
Dave M wrote:
Aha! That makes it more complicated, but you can still do stuff like

=Sum(([Cost] + [Tax]) * [Quantity])

However, if it's getting to that point, you're probably better off to do as
much of the calculation as you can in a query that then supports the
report.. If you have a calculated field in a query that looks something
like Extension:([Cost] + [Tax]) * [Quantity]) you can then have a text box
for the Exetnsion field in your Detail section, and then a summary textbox
that uses =Sum([Extension]) in the appropriate footer(s).

"DS" <bo******@optonline.net> wrote in message
news:OO***************@fe08.lga...
Dave M wrote:

You have to sum the calculation rather than refer to the name of the
calculated control (presumably a text box). So if your Detail section
contains a text box named "txtTotal" and that text box's Control Source
is
"=[Price] * [Quantity]" then your sum has to be in a text box with the
Control Source "=Sum([Price] * [Quantity])" rather than
"=Sum([txtTotal])

"DS" <bo******@optonline.net> wrote in message
news:7i*************@fe08.lga...
How do you get a sumon a calculated field in a detail section on a
report? I have a group footer that I need the sum on.
Thanks
DS

PS That calculated control is based on another calculated control.
DS


Thanks I'll give it a try and let you know.
DS
Nov 13 '05 #6

P: n/a
DS
Dave M wrote:
Aha! That makes it more complicated, but you can still do stuff like

=Sum(([Cost] + [Tax]) * [Quantity])

However, if it's getting to that point, you're probably better off to do as
much of the calculation as you can in a query that then supports the
report.. If you have a calculated field in a query that looks something
like Extension:([Cost] + [Tax]) * [Quantity]) you can then have a text box
for the Exetnsion field in your Detail section, and then a summary textbox
that uses =Sum([Extension]) in the appropriate footer(s).

"DS" <bo******@optonline.net> wrote in message
news:OO***************@fe08.lga...
Dave M wrote:

You have to sum the calculation rather than refer to the name of the
calculated control (presumably a text box). So if your Detail section
contains a text box named "txtTotal" and that text box's Control Source
is
"=[Price] * [Quantity]" then your sum has to be in a text box with the
Control Source "=Sum([Price] * [Quantity])" rather than
"=Sum([txtTotal])

"DS" <bo******@optonline.net> wrote in message
news:7i*************@fe08.lga...
How do you get a sumon a calculated field in a detail section on a
report? I have a group footer that I need the sum on.
Thanks
DS

PS That calculated control is based on another calculated control.
DS


Thanks That worked. I guess I was getting kinda deep in Calculated fields!!
DS
Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.