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
|
|||
|
|||
Totals on Footer Page
Quick Overview
Header Page ------------- Detail -SubForm 4-5 columns with Data filtered by OrderID ------------- Footer Page Is there a way to put on the Footer page a Total/Sum of a certain column from the SubForm? Basic Premise behind this page is. Order ID = X , and in the columns in the subform are all of the order lines. ONe of them is a fabric measured by Yards, we need to total the yards at the end of the page(in the Form Footer). Thanks in Advanced. |
#2
|
|||
|
|||
Totals on Footer Page
Look at the Order Entry form and subform in the Northwind.mdb
It does exactly that. -- Dave Hargis, Microsoft Access MVP "Bombay" wrote: Quick Overview Header Page ------------- Detail -SubForm 4-5 columns with Data filtered by OrderID ------------- Footer Page Is there a way to put on the Footer page a Total/Sum of a certain column from the SubForm? Basic Premise behind this page is. Order ID = X , and in the columns in the subform are all of the order lines. ONe of them is a fabric measured by Yards, we need to total the yards at the end of the page(in the Form Footer). Thanks in Advanced. |
#3
|
|||
|
|||
Totals on Footer Page
Where do I find the Northwind.mdb for access 2007? |
#4
|
|||
|
|||
Totals on Footer Page
I don't have 2007, so I don't know.
-- Dave Hargis, Microsoft Access MVP "Bombay" wrote: Where do I find the Northwind.mdb for access 2007? |
#5
|
|||
|
|||
Totals on Footer Page
I have found the Order Details Page in the Northwind Database.
I only see that it totals up the Columns inside the subform, and there appears to be no footer total in the main page. Can you be more specific as to where I can find what I am looking for. Thanks |
#6
|
|||
|
|||
Totals on Footer Page
If you open the Orders form in design view, there is a control named Subtotal
that has as it's control source =[Orders Subform].Form!OrderSubtotal Notice you don't see the subtotal on the subform, the Subtotal control on the main form displays the value. -- Dave Hargis, Microsoft Access MVP "Bombay" wrote: I have found the Order Details Page in the Northwind Database. I only see that it totals up the Columns inside the subform, and there appears to be no footer total in the main page. Can you be more specific as to where I can find what I am looking for. Thanks |
Thread Tools | |
Display Modes | |
|
|