Prev: color codes
Next: Combo box Issue
From: Ed-Masto on 10 Oct 2008 13:21
Hi All:

How do I put totals on a subform. For example, I have an sales order form
with the order details on a subform. I would like the Quantity and Extended
Price of all the lines in the sub form to sub total for the order. Any ideas?

Ed
From: Ed-Masto on 10 Oct 2008 15:41
I figured it out. The new Totals feature in 2007 is awesome!

"Ed-Masto" wrote:

> Hi All:
>
> How do I put totals on a subform. For example, I have an sales order form
> with the order details on a subform. I would like the Quantity and Extended
> Price of all the lines in the sub form to sub total for the order. Any ideas?
>
> Ed
From: John W. Vinson on 10 Oct 2008 16:12
On Fri, 10 Oct 2008 10:21:02 -0700, Ed-Masto
<EdMasto(a)discussions.microsoft.com> wrote:

>Hi All:
>
>How do I put totals on a subform. For example, I have an sales order form
>with the order details on a subform. I would like the Quantity and Extended
>Price of all the lines in the sub form to sub total for the order. Any ideas?
>
>Ed

Put two textboxes in the Footer of the subform, with control sources like

=Sum([Quantity])

--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: color codes
Next: Combo box Issue