Who is expert in Microsoft Access?

Question

In my table I have 3 fields "Gross Income" & "Total Expenses" and "Net Income" I want my net income field to calculate by its own by deducting expenses from income, what would I write in the default value of my table properties, I can do it in my form but in my table, i find it hard.

Answer 1

Tables don't do mathematical calculations. Tables only store data. You'll need to write a macro or module or VBA application that will manipulate the data in the table.

Answer 2

First, its not a great idea to store calculated items in the table, generate them on the fly.
Second, if you have to, and all data is entered via a form, you can use a trigger AfterUpdate().
Third, as best as I know, you cannot do it at the table level (at least till Access 2003).

Hope this helps