RE: Summing Fields

I think i didn't answer your one question correctly. the subform uses the
query for the order details that match the order shown on the main form. the
query has the field Ext price:=[unit price]*[Qnty]. This Ext price field is
shown on the subform. I have a control in the main form labelled subtotal.
I want the subtotal control to show the sum of the extended price fields
from the sub form....I hope that is more clear.
--
Bob Love


"Klatuu" wrote:

What error did you get?
Is your calculated control in the subform's footer like it is in the Orders
subform?

BTW using a $ in a name is a very bad idea.
--
Dave Hargis, Microsoft Access MVP


"Bob Love" wrote:

I viewed the report of the north winds and the use the expression
=Nz(Sum(Extended Price),0)....I tried this substituting my field "Ext $" for
Extended price and it gave me an error. What about using a calculated
expression "=Sum([Forms]![Order Details Subform]![Ext $]) ..... should this
work

--
Bob Love


"Klatuu" wrote:

Check out the Orders form and the Orders Subform in the Northwind sample
database. It has a very good example of how that is done.
--
Dave Hargis, Microsoft Access MVP


"Bob Love" wrote:

This hopefully is a very simple answer but I just can't seem to get it. I
want to track my orders with my venders. I'm trying to use a Main Form/ Sub
form format. The main form has my vender and ordeer fields from that table
and my sub form shows the order details (I.E. Quantity, description, unit $.)
I use a query to find all details that match the order # in the main form.
I have a field on the query the uses the expression of Qnty * Unit $ to
calculate the extended $ but I can't seem to get the sum of the extended $
to the subtotal block on the main form. I know this should be simple but I
can't seem to figure it out. Thanks in advance for any and all help.
--
Bob Love
.

Relevant Pages

  • RE: How is the ordes details retrieving the Unit Prices?
    ... between my query in which my "Order Details" Subform is based and the ... Northwind's query for which its subform is based. ... my query uses the "Product Price" from my Product Services Table ...
    (microsoft.public.access.gettingstarted)
  • RE: Summing Fields
    ... table and renamed the field unit price instead of unit $ and Ext price ... "Bob Love" wrote: ... and my sub form shows the order details (I.E. ... I use a query to find all details that match the order # in the main form. ...
    (microsoft.public.access.gettingstarted)
  • RE: Summing Fields
    ... "Bob Love" wrote: ... The main form has my vender and ordeer fields from that table ... and my sub form shows the order details (I.E. ... I use a query to find all details that match the order # in the main form. ...
    (microsoft.public.access.gettingstarted)
  • RE: Summing Fields
    ... Is your calculated control in the subform's footer like it is in the Orders ... "Bob Love" wrote: ... and my sub form shows the order details (I.E. ... I use a query to find all details that match the order # in the main form. ...
    (microsoft.public.access.gettingstarted)
  • Re: Problem with relationship??
    ... I want and would I have to change my query at all? ... The subform draws on a query which in turn draws from three ... from Orders to Order Details is one-to-many with many on the Order Details ... When I put a seriel number into the seriel number field of the subform I ...
    (microsoft.public.access.gettingstarted)