459,688 Members | 1,936 Online
+ 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 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
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" 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 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" wrote in message news:7i*************@fe08.lga...How do you get a sumon a calculated field in a detail section on areport? I have a group footer that I need the sum on.ThanksDS Right, I tried that and I still get nothing. Am I doing something wrong? Thanks DS Nov 13 '05 #3

 P: n/a 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" wrote in message news:7i*************@fe08.lga...How do you get a sumon a calculated field in a detail section on areport? I have a group footer that I need the sum on.ThanksDS 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" 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" wrote in message news:7i*************@fe08.lga...How do you get a sumon a calculated field in a detail section on areport? I have a group footer that I need the sum on.ThanksDS PS That calculated control is based on another calculated control. DS Nov 13 '05 #5

 P: n/a 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" wrote in message news:OO***************@fe08.lga...Dave M wrote:You have to sum the calculation rather than refer to the name of thecalculated control (presumably a text box). So if your Detail sectioncontains 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 theControl Source "=Sum([Price] * [Quantity])" rather than "=Sum([txtTotal]) "DS" wrote in messagenews:7i*************@fe08.lga... How do you get a sumon a calculated field in a detail section on areport? I have a group footer that I need the sum on.ThanksDS 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 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" wrote in message news:OO***************@fe08.lga...Dave M wrote:You have to sum the calculation rather than refer to the name of thecalculated control (presumably a text box). So if your Detail sectioncontains 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 theControl Source "=Sum([Price] * [Quantity])" rather than "=Sum([txtTotal])"DS" wrote in messagenews:7i*************@fe08.lga... How do you get a sumon a calculated field in a detail section on areport? I have a group footer that I need the sum on.ThanksDS 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.