calculate balance on a report

[vistor]

I have one table. I have multiple enteries for people as they attend different conferences throughout the year.

I want to take the start_amount - spent + credit fields to equal balance on my report.

I've tried doing it in the query but keep getting errors.

I've gotten the report to give me what I want by having a SUM text box on the form with this in the Control Source:
Travel_Requistion.start_amount]-Sum([spent])
but it asks for the amount parameter each time I run the report. I don't want that because people running the report would not know someone's start_amount.
Any suggestions?

 

[Guest_imported]

in your query, drag the fields start_amount, spent, and credit from your table into the criteria window. In the fourth column type:
balance: ([start_amount]-[spent]+[credit])

This should give you a result in your query that shows the balance.