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...