Group summation not working

  • Thread starter Thread starter Goldar
  • Start date Start date
G

Goldar

I have a table that contains 9 column of numbers and is grouped and sorted by
GL Account, Sequence no. In the detail section of the report, there are 9
currenct fields named curTotals1 thru curTotals9. These fields are bound to
fields in the underlying table. In the Group Footer section, I have 9 total
fields named curFTotals1 thru curFTotals9 whose controlsource are
=Sum([curTotals1]) thru -Sum([curFTotals1) thru =Sum([curFTotals9]).

When I run the report, I get a popup that says "Enter Parameter value"
corresponding to each total field. When I just enter return for each popup,
the report prints all of the detail information, but shows blanks (nulls?)
for eahc total field.

Any ideas about what I'm doing wrong?

Thanks...
 
If you have repeating fields (e.g., "Totals1", "Totals2", ...), you have a
.... spreadsheet! That's a pretty standard structure for a spreadsheet, but
will cause you nothing but trouble if you try to force Access to work with
'sheet data.

If "relational" and "normalization" are unfamiliar terms, and if you have
experience using Excel, you have some learning (and unlearning) to do if you
want to get good use of Access' relationally-oriented features/functions.

As a very first step, reconsider your table structure, before you try to do
anything else.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Apparently you are attempting to Sum a control from the detail section. You
can't sum controls. You can sum expressions or fields from your report's
record source query.
 
Copy the texbox curTotals1 thru curTotals9 from the detail section to the
group footer section and they should work. The group footer totals need to
have the same calculation as what is in your detailed section. Hope this
makes sense.
 
Back
Top