If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#Error when summing in Form
I add a NEW control to the Footer of a Subform with a Control Source
as follows: =([AmtBilled]). This will give me a value from a record of the Detail section of the same Subform. If I change the Control Source to =Sum([AmtBilled]), I get #Error. All of my controls that contain the Sum function are NOW giving me this #Error. I made this to happen with some change I have made, but I can't figure out what I have done to cause this. Can someone point me in the direction to solving this problem? Thanks... |
#2
|
|||
|
|||
#Error when summing in Form
You need to sum by control name not by column name.
-- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "iamnu" wrote: I add a NEW control to the Footer of a Subform with a Control Source as follows: =([AmtBilled]). This will give me a value from a record of the Detail section of the same Subform. If I change the Control Source to =Sum([AmtBilled]), I get #Error. All of my controls that contain the Sum function are NOW giving me this #Error. I made this to happen with some change I have made, but I can't figure out what I have done to cause this. Can someone point me in the direction to solving this problem? Thanks... . |
#3
|
|||
|
|||
#Error when summing in Form
Is [AmtBilled] a calculated field? You cannot run an aggregate function like
SUM against a calculated field. You have to use the expression used for the calculation. For instance, if [AmtBilled] = [Units] * [UnitCost] instead of Sum([[AmtBilled]) you'd use Sum([Units] * [UnitCost]) -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|