Full Version: Total on a form from values in a subform
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
earthenfairie
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...
ScottGem
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.