Depends on if you want the totals in the subform or the main form. In the subform, add an unbound text box (Total)For Footer with =Sum(FieldName) in the Control Source field to get the totals of that field. If it is to be on the main form, then create the same text box as escribed, but NOT Visible. Then make another unbound text box on the main form and in the Control Source enter =[SubformName].[Form]![Total]. Sean
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.