balance total in a field

G

Guest

I am a novice at acess and have a design where I set up 4 debit fields and 4
credit fields and a balance field. Is there a way to have the balance field
total the debits and credits and update as a new entry is posted?
 
I

Immanuel Sibero

Hi Trevea,

You should not use a table field for calculated data. Use a query for
calculated data.

HTH,
Immanuel Sibero
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Running Balance in Access 1
Checking Account Design 4
How to create a running total on a table 1
How do I query a calculated control? 1
How do I query a calculated control? 1
Running Balance (Debit and Credit) in Access 2007 4
Cumulative Total in a Query 1
summing a text box 1

Top