Hi:
At the bottom of a report, I wish to sum all the amounts that appear in a field called
Discount$ that appears on the report. I am not doing this summing in the query that
supports the report because I have sprinkled the discounts amount into every record, and
it only applies in the totals summary for each invoice.
In any case, the Field is called Discount$ and the report is called RINV1Q1. How do I
reference the field in the report (Group summry for the Invoices over a period) so that I
sum ONLY those entries that appear n the report.
The following is my attempt, and all I get is errors!
=DSum([Discount$],[Reports]![RINV1Q1])
Help Please
John Baker