 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / December 2007summing totals from subform on mainform
Hi there, I have looked through the posts to see if i could find some help on it but i still cant get things to work... I have a form called Billing Panel. I have a subform called BillingPanelTravelSubform The Billing Panel shows all the information for a work order The subform is linked by work order number There are for example 5 Travel invoices for one work order which means there are 5 records in the subform. I have a field on the subform called "T Total Travel" (which is an expression) and in the footer of the subform i have an unbound text box with the expression =sum([T Total Travel]) - This generates the #ERROR I just would like to show a total for that one work order all of the T Total Travel Amounts...... Thanks in advance so i have taken care of the #Error issue on the subform, however it is not summing all the records, just what is on that record... > Hi there, > [quoted text clipped - 20 lines] > > Thanks in advance Hi Erin, Each record on your subform has a text box for TotalTravel. Remove the txtbox called T Total Travel. To find the sum of TotalTravel for all records on the subform use an unbound textbox in the header or footer, set its datasource to =Sum([TotalTravel]). Jeanette Cunningham > so i have taken care of the #Error issue on the subform, however it is > not [quoted text clipped - 28 lines] >> >> Thanks in advance Hi Jeanette, I think I explained that wrong... Mainform - Work Order Subform - Travel Record 1 - Travel To amount = 5.00 Record 2 - Travel To amount = 5.00 Record 3 - Travel To amount = 5.00 Record 4 - Travel To amount = 10.00 Record 5 - Travel To amount = 10.00 I have 5 "Travel" records that belong to my main work order form. I want to show the total for that one work order for all 5 of the travel records so the total i would want to show in the example above in a text box on the main form would be 35.00. Thanks in advance > Hi Erin, > Each record on your subform has a text box for TotalTravel. [quoted text clipped - 36 lines] > >> > >> Thanks in advance |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.