Access XP/2003 & Subforms challenge

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

Date: Mon, 15 Mar 2004 14:10:50 -0800

I have a subform with dollar values, and have subtotaled
them in the footer of the subform as you're supposed to.
The main form then has a field that links to the subtotal,
and then adds it to other values on the main form to
obtain the total amount. All that is working great, my
subtotals and totals are calculating correctly. HOWEVER
whenever I run queries or generate reports, I get a value
of 0 for the total field on the main form (that is
calculated based on values from the main form plus the
subtotal from the subform). How do I fix this problem? The
whole point of doing a subform was to total multiple
entries for one item in the main table, and I need to
generate reports that show what the totals of the items
are. Thanks in advance.

Relevant Pages

  • Re: Access XP/2003 & Subforms challenge
    ... >them in the footer of the subform as you're supposed to. ... >subtotals and totals are calculating correctly. ... report to obtain the same total. ...
    (microsoft.public.access.forms)
  • Re: errors in Crystal Reports .NET subtotals and grand totals
    ... incorrect values if you have "Keep Group Together" set on your group. ... > has anybody else experienced arithmetic errors in .NET Crystal Reports ... > totals and subtotals? ... the grand total does not match the sum of the subtotals... ...
    (microsoft.public.vb.crystal)
  • Re: Storing Periodic One-Time Report Invoice Data
    ... Reports are for presentation and printing of data. ... totals and grand totals as you desire. ... I have a billing database that also creates invoice reports. ... invoice is created from the combination of the Main and Subform data ...
    (microsoft.public.access.tablesdbdesign)
  • Calculating totals in access
    ... In my database I have one form with a tab control on it. ... The last tab contains command buttons that open reports. ... subform to create the report. ... Most of the reports calculate totals. ...
    (microsoft.public.access.modulesdaovba)
  • Underline, overline, and double-underline for financial columns - Reports - A2000
    ... information which contain values, subtotals of those values, and totals of ... Column widths in a given report vary, and it takes a while to set up each ... Does anyone know of a technique for Reports to make the widths of such lines ...
    (microsoft.public.access.reports)
Loading