Table help needed

[Greg Rozelle]

Table help needed.

My table is set up this way

Date What Used Where Used Credit Debit Balance.

What I would like Microsoft access to do is Credit-Debit=Balance.
I would like a running balance total for every transaction I add.

I want to be able to see the balance column.

I a new user to this program. I tried some of those suggestion I
found online and can't not figure where to put the correct code or
What the correct code is.

This computer I got has access 2000 not the new version.


Thank you for any help.



Greg Rozelle

 

[John Vinson]

Table help needed.

My table is set up this way

Date What Used Where Used Credit Debit Balance.

What I would like Microsoft access to do is Credit-Debit=Balance.
I would like a running balance total for every transaction I add.

I want to be able to see the balance column.

You should NOT try to do this in a Table.

Tables are for data STORAGE - not for calculations, not for data
display or editing.

Instead, remove the Balance field from your table altogether. It
should not exist.

Create a Query based on the table; select all the fields; and type

Balance: [Credit] - [Debit]

in a vacant Field cell to calculate the balance, dynamically on the
fly.

You can base a Report on this query, and set the Running Sum property
of a textbox on the report to Over Group (or Over All) to display the
running sum.

John W. Vinson[MVP]