Microsoft Office Tutorials and References
In Depth Information
Adding Subtotals and Totals from Subforms
13. Format the new control with the numeric format you want, and edit
its label to a sensible name (such as Total Products or Order
If you don’t format the text box, Access usually displays way too many
decimal places for calculated values. On the Format tab of the property
sheet, set the Format property to Currency (or whatever format you
prefer). Set Decimal Places to 2.
14. Switch to Form view to test the control.
If all goes well, you see a text box like the one shown in Figure 4-9.
If you see #Name or #Error instead of the subtotal, check the
expression for the control on the main form carefully, and make sure that you
correctly entered the expression, the name of the control on the
subform, and the name of the subform control — the control you put on the
main form. (What a zoo!)
in the main