 | |
#1
 
| |||
| |||
|
Report Sum -
11-30-2004
, 01:55 PM
#2
| |||
| |||
|
|
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 |
#3
| |||
| |||
|
|
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" <bootybox (AT) optonline (DOT) net> wrote in message news:7i4rd.84$L71.15 (AT) fe08 (DOT) 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? |
DS
#4
| |||
| |||
|
|
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" <bootybox (AT) optonline (DOT) net> wrote in message news:7i4rd.84$L71.15 (AT) fe08 (DOT) 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. |
#5
| |||
| |||
|
|
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" <bootybox (AT) optonline (DOT) net> wrote in message news:7i4rd.84$L71.15 (AT) fe08 (DOT) 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 |
#6
| |||
| |||
|
|
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 boxfor the Exetnsion field in your Detail section, and then a summary textbox that uses =Sum([Extension]) in the appropriate footer(s). "DS" <bootybox (AT) optonline (DOT) net> wrote in message news:OO4rd.143$A12.115 (AT) fe08 (DOT) 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" <bootybox (AT) optonline (DOT) net> wrote in message news:7i4rd.84$L71.15 (AT) fe08 (DOT) 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. |
#7
| |||
| |||
|
|
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 boxfor the Exetnsion field in your Detail section, and then a summary textbox that uses =Sum([Extension]) in the appropriate footer(s). "DS" <bootybox (AT) optonline (DOT) net> wrote in message news:OO4rd.143$A12.115 (AT) fe08 (DOT) 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" <bootybox (AT) optonline (DOT) net> wrote in message news:7i4rd.84$L71.15 (AT) fe08 (DOT) 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!! |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.