RE: From Dec. 22's "Calculate balance on Report"

[vistor]

The ANSWER worked in the query, but only gave the balance for the first conference taken, any additional conference was not subtracted. Nothing showed on the report.

I guess I need a running balance? I do have a SUM of spent on the report but can't get it to subtract the Sum of spent from the start_amount to give the balance.

QUESTION:

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?

ANSWER: Dec 22, 2000

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.