How do I create sums when I have no groups?

  • Thread starter Thread starter ZBC
  • Start date Start date
Z

ZBC

I do not have any grouping in the report, just sorting.
I just want three sums at the bottom of about 35 records.
I have not used running sum before and am not sure if it will work
either ... my first attempts at tying it did not !

Bob
 
Without more information, I can only suggest using a text box in the report
footer with a control source like:
=Sum([FieldA])
Running sum has value in specific instances but should be required here. If
you need sums based on groups than you should provide some sample records
and desired results.
 
I may have been doing something wrong, but I could not get the
=Sum([FieldA]) to work until I created a false group?
 
You may have attempted to place the text box in the page footer rather than
the report footer.

--
Duane Hookom
MS Access MVP


ZBC said:
I may have been doing something wrong, but I could not get the
=Sum([FieldA]) to work until I created a false group?

Duane said:
Without more information, I can only suggest using a text box in the report
footer with a control source like:
=Sum([FieldA])
Running sum has value in specific instances but should be required here. If
you need sums based on groups than you should provide some sample records
and desired results.
Click to expand...
Click to expand...
 
Back
Top