Reducing Table

[Guest]

I am working on a DB for Accounts. I need to hold a monthly figure in one
table, lets say £10,000. I then need other tables to hold expense amounts.
When these expense amounts are added I want the monthly figure table to
reduce by that amount. Is this as simple as it sounds to do? e.g. the
monthly account figure to reduce ongoing until it reaches zero so I can see
what position i am in at any time of the month? Thanks

 

[James]

Hi

You can run an update query where you have:
[monthlyfiguretablename]![monthlyfigurefield]-[expensestablename]![expensefield]

You will need to add criteria to make sure that the correct expenses
are taken from the correct monthly figure but this depends on your set
up of your database.

James

 

[Rick B]

Typically, you would not store calculated values. Do a search on
"calculated values" and you should find hundreds of posts advising you
against it. One exception I see pretty often is "inventory value". Again,
do a search for that term and you are likely to find some solutions there.