RE: Summing Fields

When I view the form it say "#Error". I took your advice and went back and
changed the field name with the $ for the orders table and order details
table and renamed the field unit price instead of unit $ and Ext price
instead of Ext $. The control is in the detail of the main form not the
header or footer.
--
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: 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: Order Details
    ... MS Access MVP ... >> believed that no price for any product would ever change, ... >> not store it in the Order Details table, ... The reason I am asking this is that I created a query ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Order Details
    ... > The price in the Product table is the *current* price of the product. ... > not store it in the Order Details table, ... >> would this not mean repeating information - the price is already in the ... >> But if i built an expression in the query it would be DLookup and it would ...
    (microsoft.public.access.tablesdbdesign)
  • 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)