Totals on Footer Page

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bombay - 11 Apr 2008 15:42 GMT

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.

Reply to this Message

Klatuu - 11 Apr 2008 19:58 GMT

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

Signature

Dave Hargis, Microsoft Access MVP

> Quick Overview
>
[quoted text clipped - 16 lines]
>
> Thanks in Advanced.

Reply to this Message

Bombay - 21 Apr 2008 14:57 GMT

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

Reply to this Message

Klatuu - 21 Apr 2008 15:00 GMT

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

Signature

Dave Hargis, Microsoft Access MVP

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

Reply to this Message

Bombay - 21 Apr 2008 15:16 GMT

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

Reply to this Message

Klatuu - 21 Apr 2008 15:36 GMT

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.

Signature

Dave Hargis, Microsoft Access MVP

> I have found the Order Details Page in the Northwind Database.
>
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message