Total not working on report

[gemni2006]

I am trying to get a total of the amount paid by each student to total by
course. I try to create the report but each time I try it I get a new error
message. Basically I want a report to say course number and the amount of
money collected for that course. For some reason I put the =sum(amount paid)
and get an error. Any help would be greatly appreciated, even a work around.
If you have questions for me just send me an email.

 

[Jeff Boyce]

To benefit all those who might run into a similar issue, questions asked in
the newsgroup are answered in the newgroup.

You've not provided any background information about how your data is
stored, or whether you are creating your report directly against that
(unknown) table structure vs. using a query.

You also haven't described the layout of your report ... for example, are
you using the Details section to list amounts paid, or are you using a
sub-report?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[gemni2006]

Jeff, All of the information is in tables. I am looking at a form (called
roster) and it shows how much each student paid. I want to get a total for
that course. The field is called Amount Paid. When I put in =sum(amount
paid) I get an error message. Is there another way to get it to add or maybe
a sub report or something to show the total for the course at the bottom.

 

[Duane Hookom]

PMFJI but do you actually have a space in your field name? The wrapping in
the web interface breaks the line on the expression.

If you choose to create fields or other objects with names containing
spaces, you must wrap your names in []. Try:
=sum([amount paid])