RE: Summing Fields

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: 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
    ... 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: Refining query
    ... Have you ever heard the joke about Bob ... so...if I were to create a DISTINCT query of "qryBigSet" on fields ...
    (microsoft.public.access.queries)
  • Re: All hail Bob (not)!
    ... casual user to get a correct result for a simple query, you only confirm that you are an embecile. ... Much more curiously though your resort to bombastic posts (whilst a feeble trait IMO for anyone professing intellectual tendencies) seems to have recent CDTzens in thrall given the deafening silence to date. ... What is it with Bob though? ...
    (comp.databases.theory)
Loading