Re: Access XP/2003 & Subforms challenge

From: Duncan Bachen (dbachen_at_NOSPAM_olehansen.com)
Date: 03/16/04 

Date: Tue, 16 Mar 2004 09:41:55 -0500

On Mon, 15 Mar 2004 14:10:50 -0800, "littledragons4"
<anonymous@discussions.microsoft.com> wrote:

>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.

If you are doing calculations on the form to obtain your total, you're
going to have to do those same calculations in your query or in your
report to obtain the same total.

Alternately you can run the report while the form is open, and
directly reference the field on the form.

That's limiting your design though, because it's forcing you to run a
report for only one record at a time. Not sure exactly what your needs
are.

-D

---------------------
Duncan Bachen (dbachen@NOSPAM_olehansen.com)
Director of IT
Ole Hansen and Sons Inc.
---------------------

Relevant Pages

  • Re: errors in Crystal Reports .NET subtotals and grand totals
    ... the grand total does not match the sum of the subtotals... ... Subtotals and grand totals sum EVERY detail record ... whether or not they actually appear on the report. ... setting the conditional calculation to perform only when the section is ...
    (microsoft.public.vb.crystal)
  • Re: Report Subtotals - Repost - Thanks!
    ... The report is grouped by year, ... >> I have a report that creates subtotals for monthly sales, ... >> footer for annual sales and finally a footer for grand totals. ...
    (microsoft.public.access.reports)
  • Access XP/2003 & Subforms challenge
    ... I have a subform with dollar values, ... subtotals and totals are calculating correctly. ... whenever I run queries or generate reports, ...
    (microsoft.public.access.forms)
  • Re: Report Subtotals - Repost - Thanks!
    ... How would you use an IFF statement to figure out breaks between years or to ... The report is grouped by year, ... > I have a report that creates subtotals for monthly sales, ... > footer for annual sales and finally a footer for grand totals. ...
    (microsoft.public.access.reports)
  • Design reports with formulas
    ... I created a report that totals three different types of space in two ... different buildings. ... I was able to create subtotals for each type of space ... I created a text box at the bottom of the report in the report ...
    (microsoft.public.access.gettingstarted)