Re: Access XP/2003 & Subforms challenge

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: littledragons4 (anonymous_at_discussions.microsoft.com)
Date: 03/16/04 

Date: Tue, 16 Mar 2004 08:30:40 -0800

Thank you. I've tried repeating the calculations in the
query, but the problem is that it doesn't allow me to
include the subtotal field from the subform. I'm assuming
it's because it resides in the footer. So I tried it by
including the total field from the main form (that pulls
from the subform), but even though the total field on the
form shows the correct amount it still comes out at zero
in the query.

The database is to help me track my eBay sales. One item
may have multiple listings if it didn't sell the first
time, which is why I created the subform for the
listings. I need to add in all the fees associated with
the listings (the subform) to all the fees in the item
form (the main form) in order to figure out what my net
value is for the sale of the item. Keeping the form open
while running the report won't help because I'd like to
generate a report that shows all sales for the month, all
fees, and net sales.

Relevant Pages

  • Re: Database Design Help
    ... how do you think you're going to accomplish that? ... That was just a suggestion in case you needed it. ... would like to have a form with a subform on it for to track the sales. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: using a subform for data entry
    ... I have a sales table and a sales detail table on ... The primary key on the sales table is Sales order Number and on the detail ... anything from the master table. ... I try to link the two in the subform field linker. ...
    (microsoft.public.access.formscoding)
  • Re: Error when using subform
    ... To have a look at one way to set up tables for sales, ... I have an error when using a subform. ... subform will display all the items that have the same invoice ID. ... includes related records. ...
    (microsoft.public.access.forms)
  • Re: Allen Brownes Filter - Modification troubles
    ... You can filter a continuous form, and you can change the RecordSource of a continuous form. ... The main form is a Sales Order, and the subform indicates which Sales Reps ...
    (microsoft.public.access.queries)
  • Re: Access XP/2003 & Subforms challenge
    ... >query, but the problem is that it doesn't allow me to ... >include the subtotal field from the subform. ... >The database is to help me track my eBay sales. ... >the listings to all the fees in the item ...
    (microsoft.public.access.forms)