Sums in a report

  • Thread starter Thread starter Amy
  • Start date Start date
A

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?
 
Amy said:
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?
Click to expand...


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).
 
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
 
amy said:
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?"
Click to expand...


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].


 
Back
Top