RE: Summing Fields

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: Summing Fields
    ... query for the order details that match the order shown on the main form. ... shown on the subform. ... "Bob Love" wrote: ... I use a query to find all details that match the order # in the main form. ...
    (microsoft.public.access.gettingstarted)
  • RE: Summing Fields
    ... 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
    ... 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
    ... 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)
  • Summing Fields
    ... want to track my orders with my venders. ... 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)
Loading