Report balance

M

Ms2327

I have created a report in access and I need to have the ending balance
reflected at the top. I have an Invoice Total, Amt Paid, and Balance columns
with one or more invoices. What do I need to do to have the ending balance
reflected on the report?
 
A

Allen Browne

Access uses a 2-pass approach to the report, so you should be able to put a
text box in the Report Header section (not Page Header), and set its Control
Source to:
=Sum([Invoice Total])
or whatever the field is called.
 
Top