Totals

[Feprincess]

How do you formulate for a total for each line in your report and then a grand total for each group?
thanks

 

[Rabbie]

rough instructions

In the total box on your line use the formula =sum(boxes)

in the group footer have something like =sum(total)

HTH

 

[Feprincess]

I have 20 columns across and want to get a total for each row.
I also want a grand total for each group.
Is this possible?
thanks

 

[Feprincess]

would it be easier to do the calculation in the query?

 

[statsman]

Rabbie is correct.
Insert a blank text box in the Detail section of the report where you would like the line total. In the Control Source type in:
=Sum([field1]+[field2]+[field3]) with the fields being the fields you would like to have summed.

For the Grand Total, in the footer section insert a blank text box and type in
=Sum([fieldname]) of the field you want a total for.

If you want a Grand Total of your line totals, it would be easier to do it in a query.
Using the query that is currrently controlling the report, go to the first blank box and enter:
LineTotal:Sum([field1]+[field2]+[field3]) as above.
In the next blank box enter:
GrandTotal:Sum([LineTotal]

Enter a text box in the report in the Detail Section and set the control source to LineTotal.
Enter a text box in the footer and set the control to GrantTotal

 

[Feprincess]

Danke

Ok, I did exactly what you said to do in the Query as well as the Report.

When I input the calculation in the Query I get, "you tried to execute a

query that does not include the specified expression 'SCHNO' as part of an

aggregate function.

SCHNO is a field in query, but is not part of my sum calculation...

When I tried it in the Report in the Detail section I get

1.0068914467317E+40.

I'm ready to stick an icepick in my temple!

Anybody live in SF? I will pay you to tutor me...

 

[statsman]

Change the query fields LineTotal and GrandTotal from "Sum" to "Expression"

 

[Feprincess]

Do you mean...

=expression instead of =sum

 

[Feprincess]

So I tried it without the sum.
I put =student1u+...
All it did was enter each number from the column but didn't add them together?

 

[statsman]

You must be more specific. Are you talking about the expression on the report or the expression in the query? Which of the two options are you attempting?

Don't forget, your field names must be enclosed in square brackets and the entire math function must be enclosed in regular brackets.

Example:

If you are trying to enter a line total on your report - NOT IN A QUERY it would read:

=Sum([field1]+[field2]+[field3])

The syntax would be different if you are trying to do it in a query. You must give the expression a name, followed by a colon, followed by the math

LineTotal: ([field1]+[field2]+[field3])

Hope this helps.

 

[boblarson]

LineTotal: ([field1]+[field2]+[field3])

Hope this helps.

Just noticed after posting...the purple smiley face is a colon

You can get past that part of how it converts the colon and left paren into a emoticon by just putting space after the colon.

 

[Feprincess]

You must be more specific. Are you talking about the expression on the report or the expression in the query? Which of the two options are you attempting?

Don't forget, your field names must be enclosed in square brackets and the entire math function must be enclosed in regular brackets.

Example:

If you are trying to enter a line total on your report - NOT IN A QUERY it would read:

=Sum([field1]+[field2]+[field3])
Hope this helps.

I'm trying to do it in the report and have set up my calculation exactly like the one above. Maybe something didn't transfer from the query but when I look at my report in data sheet view all the right numbers are in the right columns.
thanks

 

[Feprincess]

Now it's asking me for a parameter value.
I've done something very wrong somewhere along the line.
Thank you for your help.

 

[statsman]

A request for a parameter value would generally be called from a query. An example would be placed into the criteria of one of the fields in the query. You enclose it in square brackets and place somthing like [Date of Report] if you would like to enter the Report Date manually.

Go back and check your query. Are there any unknown things in square brackets. You may have left some to the remnants of your previous attempts there. As I recall you were previously trying to formulate your line totals and grand total in the query.

 

[statsman]

I was just re-reading the thread. Perhaps I wasn't clear earlier.

You can create your line and grand totals in the report itself
OR
in the query that runs the report.
NOT IN BOTH.
You must choose which method you would like to use.

Your Grand Total must go into the report footer section of the report, Not the detail section.