The Sum function isn't working

[UBcollegeboy]

Ok so I have a text box called Weight (Kg) and I want to put another text box in the footer to add all of the Weight (Kg). So I put the text box down there and in the control source i put =Sum([Weight (Kg)]), however when I switch to form view it shows a #Error. Now I change that to datasheet view, because I was in continuous form and the sum function doesn't even work. Everything else works, the average works, the count works but when I try to add it it doesn't work. These are just normal numbers like 25.1, 24.4, etc. I am seriously puzzeled to why it doesn't work when it works perfectly fine on another database.

 

[rapted]

Ok so I have a text box called Weight (Kg) and I want to put another text box in the footer to add all of the Weight (Kg). So I put the text box down there and in the control source i put =Sum([Weight (Kg)]), however when I switch to form view it shows a #Error. Now I change that to datasheet view, because I was in continuous form and the sum function doesn't even work. Everything else works, the average works, the count works but when I try to add it it doesn't work. These are just normal numbers like 25.1, 24.4, etc. I am seriously puzzeled to why it doesn't work when it works perfectly fine on another database.

Not an expert myself but had the same problem with an invoice app. You may need to have an unvisible textbox but to determine fully, need the code. Is it just just one form or do you need to get the totals of a subform of weights?? Please explain more

 

[UBcollegeboy]

what it is is the Weight Kg text box is in a subform and I created the other text box so I can get the total of it in the footer within the subform. Subform name is "Bin Allocation Subform" My main purpose is to reference that total text box out to a text box in the main form and I have that working, (right now it says #error because the one in the subform says #error). I don't know what is wrong with it. All of them are visible.

 

[CEH]

If I'm reading your post correctly... try a textbox in the subform to SUM..or in the query.. reference that in your unbound on the main form.

 

[UBcollegeboy]

the text box with the SUM function is in the subform but as I said it doesn't work. It is quite annoying because I don't know what is wrong with it.