Running balance in query

[Guest]

Hi

I would like to create a running balance in a query.

I have the following columns:

Income Expenditure Balance
2300 4500
6700 2300
7200 1200

Thanks.

 

[Joseph Meehan]

Hi

I would like to create a running balance in a query.

I have the following columns:

Income Expenditure Balance
2300 4500
6700 2300
7200 1200

Thanks.

You really should use a form or report for this kind of work.

 

[Guest]

Ok

How would I do this in a form.
--
Ralph

You really should use a form or report for this kind of work.

 

[Joseph Meehan]

Ok

How would I do this in a form.

Can I assume you want? :

Income Expenditure Balance
2300 4500 -2200
6700 2300 2200
7200 1200 8200

If so you would have an unbound control equal to Income - Expenditure and
another unbound control equal to the result of the first as a sum.