Feb 28 2006, 02:48 PM
I have built a quote form with a subform that contains information for machine rates. How do I calculate the total labor costs from the subform to be entered into a control on the main form? Any help would be appreciated. Thanks in advance for all your help...
Feb 28 2006, 02:51 PM
A couple of ways. You could put a total in the subform footer with a Sum(). Then reference that control on the main form. Or you could use a DSUM in a control on the main form.
Note: The mainform control would be unbound. There is no need to store this info. As a general rule we don't store caclulated values.