Sums in a report

[Amy]

I have a report that lists different amounts. I would
also like to add the amounts at the end of each account.
Is there an equation to run a sum in a report?

 

[Marshall Barton]

I have a report that lists different amounts. I would
also like to add the amounts at the end of each account.
Is there an equation to run a sum in a report?

If you use Sorting and Grouping (View menu) to speciy a
group (with a footer section) on the account field, then you
can use a text box in the group footer section with an
expression like =Sum(amount).

 

[amy]

That worked great for one. Now I am trying to just get
that balance go to another report where there is only name
and number for the account. I have the number set as my
primary key. I go to the control source and select it out
of the report, but then I get "Name?"

Any advice?

Thanks,
Amy

 

[Marshall Barton]

That worked great for one. Now I am trying to just get
that balance go to another report where there is only name
and number for the account. I have the number set as my
primary key. I go to the control source and select it out
of the report, but then I get "Name?"

Either you must include the field in the report's record
source before you can attempt to Sum it or, alternatively,
you might be able to use the Sum function directly in the
report's record source query if you can make it into a
Totals (Group By) query
--
Marsh
MVP [MS Access].