Report balance

[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?

 

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