sum columns

nanny

Registered User.
Local time
Yesterday, 16:23
Joined
Dec 16, 2008
Messages
19
I have a subreport with 10 columns and I need to total each column? Right now it totals all 10 columns. Any help appreciated.
 
I am a little unclear as to what you want to do.

If you want this:

.....A.....B.....C
.....1.....2.....3
Sum1....2.....3

Place a blank textbox into the report footer with =Sum([fieldname]) for each field you want summed.

If you want:

.....A.....B.....C.....Sum
.....1.....2.....3.......6

This would best be accomplished by doing the sums in your report query and posting them on the report.
 
Thanks for your reply, I have attemped to design a report that looks like Excel. I have a main report which has two sub reports with 10 columns. Patient chart numbers display vertically across one subreport and the Yes,No or N/A results are lined down the second subreport. The main report has the Questions. I will need the result of each patient chart totaled. By the way, each question is worth a different amount of points... I included points fields in my table and set the default value for each question (seemed like a good idea) however I did not include a field to store the actual points based on the answer. I am self taught and right now my report card don't look so good. Thanks again for your time.
 

Users who are viewing this thread

Back
Top Bottom