RE: Summing Fields

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
    ... "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)
  • 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)
  • 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: Working with many-to-many relationships
    ... Use the query as the "table" name, and you now have access to the product ... Allen Browne - Microsoft MVP. ... asking about originally (or I am missing the understanding that it does do ... the Order Details table serves as a "bridge" between the Orders ...
    (microsoft.public.access.reports)
  • RE: Just starting to design a form (or is it a query?)
    ... displays the correct information, but in an ugly table format. ... that I don't use a query at all? ... that match an ID in the Assessment table. ... Now, assuming this is the case, what you need is a form with a sub form. ...
    (microsoft.public.access.gettingstarted)