If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I need to Sum a calc. control in subform and show in main form
Hello,
I have a main form called Customers that has info such as phone, address etc. Then a subform called orders which has shipping and tax info and the orders subform has a Order Details subform that contains the specific info and price of each item. I currently the order details subform calculate the exact price of each item (excluding tax). Then the orders subform sums the price of each item and adds the shipping cost which is the total for each customers order. Now I need help displaying the total or sum of each order in the main Customers form. Everything I try either gives me an error! anyone have any ideas? Thank you in advance, Beth |
#2
|
|||
|
|||
I need to Sum a calc. control in subform and show in main form
On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "SubformReference.mdb" which illustrates how to do a number of things referencing controls on subforms and subsubforms, including this. -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "Beth" wrote in message ... Hello, I have a main form called Customers that has info such as phone, address etc. Then a subform called orders which has shipping and tax info and the orders subform has a Order Details subform that contains the specific info and price of each item. I currently the order details subform calculate the exact price of each item (excluding tax). Then the orders subform sums the price of each item and adds the shipping cost which is the total for each customers order. Now I need help displaying the total or sum of each order in the main Customers form. Everything I try either gives me an error! anyone have any ideas? Thank you in advance, Beth |
Thread Tools | |
Display Modes | |
|
|