Totals on Footer Page

[Bombay]

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.

 

[Klatuu]

Look at the Order Entry form and subform in the Northwind.mdb
It does exactly that.

 

[Bombay]

Where do I find the Northwind.mdb for access 2007?

 

[Klatuu]

I don't have 2007, so I don't know.

 

[Bombay]

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

 

[Klatuu]

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.