UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Total on a form from values in a subform    
 
   
earthenfairie
post Feb 28 2006, 02:48 PM
Post #1

UtterAccess Addict
Posts: 183
From: Gainesville, FL
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...
Go to the top of the page
 
+
ScottGem
post Feb 28 2006, 02:51 PM
Post #2

UtterAccess VIP / UA Clown
Posts: 25,195
From: LI, NY
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.
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th June 2013 - 02:38 AM