Total across columns

  • Thread starter Thread starter bagia
  • Start date Start date
B

bagia

I've created a report with groupings...group by Faculty.
Is there a way to create a total going across the
columns. I want to be able to create a sum for each
row. Is this possible?

Faculty |Course |Ques 12|Ques 14|Ques 21| Total
Allen |CSIS-325|3.86 |4.09 |4.33 | ???
|MGMT-641|4.18 |5.15 |5.33 | ???

Total |8.04 |9.24 |9.66 | ???

Any suggestions or advice?
 
There's a couple ways. If the columns you mention (the
various "Ques") are actual columns in your data table or
query, create a "Total" column in the query by doing the
following in the "Field" box in the query:

Grand Total: [Ques 12]+[Ques 14]+[Ques 21]

Another way is in the Report itself. Create a Text Box
with the Control Source of:

=Sum([name of Taxt box with the first Que]+[name of Taxt
box with the first Que]+[name of Taxt box with the first
Que])

Hopefully this helps
Dan
 
Thanks for your help. There's only one column with the
name Question, but there can be 3 different questions in
it. I created a crosstab for the table and then created
a report based on it and it did the job.

Again, thanks for your help.
-----Original Message-----
There's a couple ways. If the columns you mention (the
various "Ques") are actual columns in your data table or
query, create a "Total" column in the query by doing the
following in the "Field" box in the query:

Grand Total: [Ques 12]+[Ques 14]+[Ques 21]

Another way is in the Report itself. Create a Text Box
with the Control Source of:

=Sum([name of Taxt box with the first Que]+[name of Taxt
box with the first Que]+[name of Taxt box with the first
Que])

Hopefully this helps
Dan
-----Original Message-----
I've created a report with groupings...group by Faculty.
Is there a way to create a total going across the
columns. I want to be able to create a sum for each
row. Is this possible?

Faculty |Course |Ques 12|Ques 14|Ques 21| Total
Allen |CSIS-325|3.86 |4.09 |4.33 | ???
|MGMT-641|4.18 |5.15 |5.33 | ???

Total |8.04 |9.24 |9.66 | ???

Any suggestions or advice?

.
Click to expand...
.
Click to expand...
 
Back
Top